concatenate all cells that match date criteria and return string.
Jul 31, 2021 · I have a list of dates with data and notes associated with them many of the dates repeat. i used the unique function to separate them into discrete days, and now i wish to bring …
School grades spreadsheet - Microsoft Community
Nov 23, 2021 · Most of us in school have a spreadsheet with all our scores to help us optimize our scores in school. this formula for excel can help that, all you need to use it is to designate a …
Find email match in another column and move it in row next to it.
I am looking for an excel formula that will have the email address in column H to find the same address in column F and place it on the same row next to it in column G. For instance, H2 can …
I am trying to get the formula for excel that will provide a ...
Oct 18, 2024 · I am trying to get the formula for excel that will provide a birthdate. Exact year plus months! For example: the child is 1 year and 4 months old I would like the answer to be in 1 …
excel sumif (based on colour code) forumal help
I have the colour palette hex codes, so not sure if can build a formula using the codes. The worksheet, already has conditional formatting it it, where if cell value in column N is zero, then …
Microsoft Community
Microsoft Community
Trouble ignoring blank cells while finding the minimum difference.
Aug 18, 2024 · I am trying to find the minimum difference between two sets of numbers, but am having problems with the formula not ignoring blank cells... My current formula is =MIN …
Gráficos Excel 2007 - Legendas - Séries com valores vazio
Dec 16, 2010 · Gráficos Excel 2007 - Legendas - Séries com valores vazio Bom dia pessoal, Estou tendo alguns problemas com os gráficos do excel 2007 e gostaria da ajuda de vocês. …
Can't filter properly a column in Excel Online
Feb 25, 2019 · Dear Microsoft Community, I am having a problem with an excel spreadsheet on an Excel Online Sharepoint. The filter option doesn't work in the columns, it isn't filtering nicely …
Fórmula para calcular la edad en Excel ≈ Office
Quiero saber como puedo ejecutar la formula en excel donde pueda, calcular el valor de la edad, a la fecha de ingreso a formulario, la ejecuto pero me da valor de ...