LinkBack URL
About LinkBacks
I am trying to recall the comment for Stock and Repair (Column E and G) into the tab called Table by Brand and Type.
I am only trying to recall the comment if the Traffic for Stock and Repair is "X" or < 49% (Using a conditional formatting)
I am trying to recall the comment for Stock and Repair (Column E and G) into the tab called Table by Brand and Type.
I am only trying to recall the comment if the Traffic for Stock and Repair is "X" or < 49% (Using a conditional formatting)
Last edited by Jerseynjphillypa; 05-25-2012 at 11:53 AM.
I don't understand how you are calculating the %'s
Ben Van Johnson
Sorry.. I changed it to numbers to make it easier. So if X < 3 then the cell are marked with a X.
Hi
Maybe in G2 and copy down...?
=IF(F2<3,2,4)
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.
I need the brand and type to match.. I am also trying to pull in the Comments if X < 3 for Stock and Repair under column C and G.
I am trying to only CONCATENATE the comments under detail notes if column A or C is greater than or equal to 2.
But if the column is blank I don't want the comment to come up.
So for line 2, i need to say "Test" under Detail Notes and for line 3 I want it to say "Test Hello"
Hi
A little...long formula, but i think it works.
In E2 and copy down.
=IF(AND(A2>=2;C2>=2);B2&" "&D2;IF(AND(A2>=2;C2="");B2;IF(AND(A2="";C2>=2);D2;"")))
thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks