Hi,
I was using a pivot table for a dashboard summary but due to a change in code, there are some certain fields that won't display correctly as it's now text format and not date and time etc.
Anyway, I'm good with the basic lookups but not with index and match etc which is what I think is needed for this...
Basically I want a list to be populated based certain criteria.
Example, I have a spreadsheet of 39 columns and on going rows. Column E is what I want to be displayed in this list, but only to be shown if both columns T and AA are both blank. At any point in the day there could be between 10 and 15 cases that meet this criteria so I don't mind having a column full of formula on my dashboard.
Hopefully I've explained this well enough for you good people to help me.
I was using a pivot table for a dashboard summary but due to a change in code, there are some certain fields that won't display correctly as it's now text format and not date and time etc.
Anyway, I'm good with the basic lookups but not with index and match etc which is what I think is needed for this...
Basically I want a list to be populated based certain criteria.
Example, I have a spreadsheet of 39 columns and on going rows. Column E is what I want to be displayed in this list, but only to be shown if both columns T and AA are both blank. At any point in the day there could be between 10 and 15 cases that meet this criteria so I don't mind having a column full of formula on my dashboard.
Hopefully I've explained this well enough for you good people to help me.