Hi,
Se attachment.
I have a huge document where I have to find a formula.
Look on the example attached.
Let's take 16 as an example. I have 16 in C2. I want it to be in every cell fra B2 to B6 (until the last "L" in column A before "H").
Is there any formula I can use? Any other good ideas?
Kind Regards
JohnnyWalker
hi JohnnyWalker, how about:
=IF(C2="",B1,C2)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Put this formula in B2:
=IF(A2="H",C2,B1)
then copy down by selecting B2 again then double-clicking the fill handle (the small black square in the bottom right corner of the cursor).
Hope this helps.
Pete
In B2 cell
Formula:
Please Login or Register to view this content.
Drag it down.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi again,
What if I have numbers like in this new attachement?
Which formula I can use?
Thanks for the help!
My formula in post #3 would do that for you.
Pete
Perfect! Thanks!!
JohnnyWalker
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks