hi guys if anyone could help me with formulas id really appreciate it ( im truly rubbish at formulas )
i have attached spreadsheet with what i require on.
Much appreciated
hi guys if anyone could help me with formulas id really appreciate it ( im truly rubbish at formulas )
i have attached spreadsheet with what i require on.
Much appreciated
Last edited by sdts; 01-14-2011 at 12:07 PM.
In C14:
=IF(OR(C1={"a","c","d","e","f","l"}),F2,"")
in D14:
=IF(OR(C1={"a","c","d","e","f","l"}),I2,"")
In E14:
=IF(OR(C1={"b","g","h"}),M2,"")
or
=IF(C14="",M2,"")
Note:
Format C14 and D14 as Date
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
fantastic nbvc
really much appreciated
kind regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks