Returning column contents based an a formula result in another row
I have a large spreadsheet that has many training courses listed. I am currently trying to do a search based on training hours...
so column z (training hours) <1 then I want to have the formula display column A1, B1, C1 in individual cells..
Anyone have any idea how to do that?
Hi
please post a sample file showing some data and expected results. Thx
You mean display A1 if Z1<1, else, for example, blank?
=IF(Z1<1,A1,"")
Quang PT
That worked! since I have 3 columns want it to do this data I'll have to use the formula in the 3 columns..
A2 formula =IF(Z1<1,A2,"") B2 =IF(Z1<1,B2,"") C2=IF(Z1<1,C2,"")
Is there a simpler way to do this?
Really Appreciate this
You can not use A2 to display itself. Use another cell instead, i.e , AA2=IF(Z2<1,A2,"")
Actually I am doing it on another sheet within the list.. it works.. not elegant but gets it done!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks