Forum menu
Thanks for yesterday's, all done now apart from this last bit - I won't even attempt to post up what I've mangled so far.
Simply....
If column C3:C500 holds a date that is 8 days or more previous to today's date
and
Column F3:F500 holds a "1" for that particular [b]row[/b]
then
Output the actual text that is held in Colum B for that particular row
Onto "Stats" tab AF8 and any others onto AF9, AF10 etc.
Beer/charity donation for whoever can help sort this!
Thanks, Rich
[IMG] 
[/IMG]
Bugger, can someone report this please - wong forum 😳
Presuming the data above is on sheet1 then
On the stats sheet in column AF:
=IF(Sheet1!C3<(TODAY()-7),IF(Sheet1!F3=1,Sheet1!B3,"Not 1 in col F"),"NotOld")
Above formula will tell you why it is not returning value of B, you may want to get rid of these bits
Assuming when thre is a date in column C that is greater than 8 days ago AND there is a 1 in the corresponding cell in column F, then you want cell AF8 in the stats sheet to contain the information held in column B in the corresponding cell? then I think the AND function will work quite well...
=if(and(sheet1!c3>TODAY()-8, sheet1!f3=1),stats!AF8=sheet1!b3,"")
I may have the syntax not qute right, but hopefully you get the gist.
=IF(AND((TODAY()-Sheet1!C1)>=8, Sheet1!F1=1), Sheet1!B1, 0)
pasted into AF8 I guess,
It's only 497 records, just type it in 🙂
Right, thanks all very much - I've settled on this (as I vaguely understood it!)
=IF(Sheet1!C3<(TODAY()-7),IF(Sheet1!F3=1,Sheet1!B3,"Not with Design"),"Under 7 Days")
There's only going to be a handul of instances though where the conditions will be true and output the contents of Sheet1C3(and these are the ones I really care about).
What I have now is a long table, which I've addeded some cond formatting to highlight the occurences, but is there any way of adding a table to read off this one, so the few occurences are just listed in succession (so no need scan though a 500 row table?)
Thanks, Rich
Add your formula above to the table and then use a pivotable and filter by the records you want to show.
aye, a pivot table (other thank freaky VBA) usually is the only thing that will change it's size to show different volumes of data according to criteria.
There are ways of doing it with static expressions but it's v complex.
Well managed to get it all bodged somehow, so thanks for that (easy when you know!)
- as there was multiple involvement, anyone want to shout up to suggest a charity, otherwise will be NSPCC?