I have the following formula. =IF(COLUMNS($B:Y)<ROWS($1:12),"",INDEX($A25:$C25,CEILING(COUNT($B25:Y25)/12,1))*INDEX($AP$30:$AP$32,CEILING(COUNT($B25:Y25)/12,1))/12)
How can I do a search and replace on the four instance of "/12" in this formula? I would like to replace it with "*INDEX(D30:D32,$B$34)"
Well, at the risk of stating the obvious, use the normal Find & Replace functionality in the Find & Select Editing area of the ribbon.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
That doesn't work. I just want to replace the final "/12" with something but there are multiple instances of that. Even if I select more it won't work because then I'll be replacing cell references. Booooooooooo.
@ Amartino
What's with theabout.Booooooooooo.
Did you followed the Find and replace suggested to you?
Find What :/12
Replace with : *INDEX(D30:D32,$B$34)
select ->>>Option
Select -> Look in: Formula
Replace All.
If you've done it right and solved the problem, please take time to read forum rules again specifically forum rule: #6b and #9
Thanks.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
That's fine. But if you look at the formula you'll notice that there are multiple instances of "/12". I only want to replace the final instance in all of the formulas.
=IF(COLUMNS($B:Y<ROWS($1:12),"",INDEX($A25:$C25,CEILING(COUNT($B25:Y25)/12,1))*INDEX($AP$30:$AP$32,CEILING(COUNT($B25:Y25)/12,1))/12)
We warned you many many many times to stop post duplicate threads and comply with our forum rules.
You choose to ignore us and continue to do anything you like.
A time out for 2 weeks, perhaps will helps you to understand that the only thing that we ask from you is to comply-as everyone of us does, with forum rules.
Thread closed
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks