I am working on an index table that I have copied several times (25 to be exact). My table does use $$ to isolate a cell, but the increment of the cell I wish to change is by +1 and if I copy the entire index table if I remove the $$ it will add +22 to the cell value and that is too much.
Is there a way that I can highlight the index completely and edit all instances of "cell $$" for "cell $$+1"
Thanks,
Editing all the cells manually one at a time makes me feel like playing ms pacman.
Hard to say without you uploading an example showing exactly what you are doing. Based on what I think you are doing, I would, with the $ in place, I would copy it to one row above where you want it to be. Then I would remove the $ (Search and replace with options set to formulas) and copy and paste it that final row.
Does that help?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
=IF(Sheet1!$N$14="Melee",LARGE(J365:J370,3),LARGE(J365:J370,5))
=IF(Sheet1!$N$14="Melee",LARGE(J365:J370,1),LARGE(J365:J370,2))
=LARGE(J365:J370,3)
Thanks for your reply,
Here are three cells our of about 120 of my index. I am manually increasing the value $n$14 to $n$15. If I copy the entire table it it preserves everything correctly but increments the n value out of proportion.
I can't seem to find how to search for options in formula.
Cheers,
=IF(Sheet1!$N$14="Melee",LARGE(J365:J370,3),LARGE(J365:J370,5))
=IF(Sheet1!$N$14="Melee",LARGE(J365:J370,1),LARGE(J365:J370,2))
=LARGE(J365:J370,3)
Thanks for your reply,
Here are three cells our of about 120 of my index. I am manually increasing the value $n$14 to $n$15. If I copy the entire table it it preserves everything correctly but increments the n value out of proportion.
I can't seem to find how to search for options in formula.
Cheers,
oops, double post
Okay, makes more sense now but my answer is the same.
Step 1. Copy and paste the table/column/rows 1 row above where you want it. If there were headers there, you'll need to repaste them in when you're done.
Step 2. Select your replanted table. Find and replace (CNTRL H) Options set to "Look in Formulas" Find $, replace with nothing. Replace All.
Step 3. Copy your replanted table and move it down one row. Replace your headers if you need to.
Not very efficient but better than doing it cell by cell.
Another option is, with $ in place, just paste it where you want it, and do a Find and replace (look in formulas) $N$14 replace with $N$15 That might be easier.
Brilliant!
If I highlight the table, and hit ctrl-h it will systematically go from cell to cell replacing the values, very not bad!
You've earned your added reputation,
Cheers,
Brilliant!
If I highlight the table, and hit ctrl-h it will systematically go from cell to cell replacing the values, very not bad!
You've earned your added reputation,
Cheers,
You need to be careful with that. If you just do a replace 14 with 15 and there's a J214 in there, it'll change it to J215. $N$14 should be safe.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks