LinkBack URL
About LinkBacks
john dalton 
I have sheet that looks a t data range and sees if a task is completed or outstanding.
I need a formula for a column to run alongside 2 counter columns that indicate the job status.
Please see the attached sheet with desired outcome.
Thanks
I have sheet that looks a t data range and sees if a task is completed or outstanding.
I need a formula for a column to run alongside 2 counter columns that indicate the job status.
Please see the attached sheet with desired outcome.
Thanks
Hello
Perhaps in I2 and copy down?
Formula:
=IF(SUMPRODUCT(('Display Sheet'!$C$10:$C$29=A2)*('Cleaning Schedule'!$B$1:$D$1='Display Sheet'!$C$6))=0,1,2)
EDIT:
Also in J2 and copy down..
Formula:
=IF($I2=1,"",MAX(J$1:J1)+1)
In K2 and copy down.
Formula:=IF($I2=2,"",MAX(K$1:K1)+1)
Last edited by Fotis1991; 03-04-2014 at 06:18 AM. Reason: EDIT
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you great solution !
You are welcome and thanks for the feed back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks