Forum Discussion
formula for conditions (within date range AND including text)
Hi there, I'm looking for a formula that extracts information from a spreadsheet which is: - between 2 dates from 1 column and includes a text from another column e.g. dates 1/7/2021-30/6/2022 ...
SergeiBaklan Hi there, i believe it would be array and i'm using sharepoint excel
Don't know what is SharePoint Excel, anyway
If you information like this
which result and where shall be? Perhaps you may share small sample file?
SergeiBaklan Hi there, im trying to create a code for my dashboard tab which takes information from the main tab which holds the data.
Heres the main tab with the data.
Here is the dashboard:
Hope this makes things clearer. Please let me know if you require further clarification
Sorry, I see practically nothing on second screenshot. Is it possible to share Excel file with exactly same information and desirably manually created dashboard for the sample?
Hi SergeiBaklan can you see it now?