Forum Discussion

Copper Contributor

Oct 28, 2021

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 ...

admin

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Oct 28, 2021

T_Bounce_Back_Project

Depends on

a) which version of Excel do you use

b) which kind of information you'd like to extract (scalar value, array, etc)

T_Bounce_Back_Project

Copper Contributor

Nov 05, 2021

SergeiBaklan Hi there, i believe it would be array and i'm using sharepoint excel

SergeiBaklan
Diamond Contributor
Nov 05, 2021
T_Bounce_Back_Project

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?
- T_Bounce_Back_Project
  Copper Contributor
  Nov 08, 2021
  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
  - SergeiBaklan
    Diamond Contributor
    Nov 08, 2021
    T_Bounce_Back_Project
    
    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?