Google Spreadsheet Post #1369
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 10, 2013
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 10, 2013
user malvaoo (http://productforums.google.com/forum/?zx=aa774cqrbnbg#!category-topic/docs/spreadsheets/BRu_U2OoER0)
HELP: Formula to return only ROW 1 values that contain a specific value in their columns?
Example: A1 has "Event 1", B1 has "Event 2", C1 has "Event 3."
Let's say "John" is listed somewhere (could be anywhere) under Event 1 and 3, but not 2. I want a single formula to return all the events John is listed under. If the formula is in G1, I want it to return "Event 1" in G1 and "Event 3" in H1 (Event 2 is skipped).
Any help? :D
------------------------------------------------------------------------------------------------
HELP: Formula to return only ROW 1 values that contain a specific value in their columns?
Example: A1 has "Event 1", B1 has "Event 2", C1 has "Event 3."
Let's say "John" is listed somewhere (could be anywhere) under Event 1 and 3, but not 2. I want a single formula to return all the events John is listed under. If the formula is in G1, I want it to return "Event 1" in G1 and "Event 3" in H1 (Event 2 is skipped).
Any help? :D
------------------------------------------------------------------------------------------------
No comments:
Post a Comment