Oct 28 2021 09:49 AM
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 and the text would be Y.
So far i know how to do them separately but i need some help to put them together
Thank you in advance!
Oct 28 2021 01:36 PM
Depends on
a) which version of Excel do you use
b) which kind of information you'd like to extract (scalar value, array, etc)
Nov 05 2021 09:38 AM
@Sergei Baklan Hi there, i believe it would be array and i'm using sharepoint excel
Nov 05 2021 09:59 AM
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?
Nov 08 2021 01:50 AM
@Sergei Baklan 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
Nov 08 2021 02:03 PM
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?
Nov 08 2021 02:33 PM
Are you trying to filter the data? If so, perhaps
= FILTER(
Table,
(ReferralDate<=1/7/2021)*(ReferralDate>30/6/2022)*(InWork="Y"),
"No results"
)
Nov 09 2021 01:34 AM
Nov 09 2021 03:39 AM
Nov 09 2021 05:58 AM
Nov 15 2021 03:31 AM
Hi @Sergei Baklan can you see it now?
Nov 15 2021 04:18 AM
Nope, sorry, I found no file with the sample.