LinkBack URL
About LinkBacks
ex)
Column A has different numbers ranging from 1-100
I want to pull every value in Column G that has a value of "60" in column A.
Any help would be greatly appreciated!
Thanks.
ex)
Column A has different numbers ranging from 1-100
I want to pull every value in Column G that has a value of "60" in column A.
Any help would be greatly appreciated!
Thanks.
Hi -
When you say "pull every value", do you mean you want to sum those together? Or what? Can you provide an example?
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
In H2 put this formula and copy down:
=IF(A2:A20=60,G2:G20,"")
The values that I am looking for in column G are Text Values.
imagine below
COLUMN A COLUMN G
1 MONKEY
5 DOG
52 CAT
62 MOUSE
60 ALLIGATOR
23 ELEPHANT
15 LION
60 FISH
in the scenario above I want to pull "ALLIGATOR" and "FISH" because they both share the value "60" in Column A
See the attached file showing how this works. Adapt your ranges to suit the need.
Thank you!
Glad to help! Please mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks