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 ...
Depends on
a) which version of Excel do you use
b) which kind of information you'd like to extract (scalar value, array, etc)
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
