Home |
Search |
Today's Posts |
#18
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ed, thanks for the closure note.
You might have hit some adaptation? / typo? problems. Perhaps just try direct copy paste from the sample file's formula bar to your sheet's formula bar, then edit to suit. Ensure that the sheetnames referenced by INDIRECT match exactly (except for case) what's on the sheet tabs. Look-out for any "extra" spaces within actual sheetnames (on tabs) vs what's indicated within the cells, or vice-versa. All it takes is an extra space somewhere (or a simple typo, maybe a "1" mistaken for an "l") to throw the matching off. Retain the earlier sample file (with the working implementation) as the reference point. When you're back onto this in future, if you still can't solve the adaption issues, just put in as new post(s) to the newsgroup, giving the relevant details (paste the actual formulas which didn't work, for example), and I'm sure there would be responders around then who would be able to help. All the best. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "milkman" wrote in message ... Max: Just a quick note. I was trying your last idea but was so tired I think I incorrectly wrote the formula as it didn't work. We know however that it will due to the fact that you wrote it in a copy of my work. Anyway, I have had to back burner that project to work on others. I will get back with you when I can return to the excel work. Again, thanks! Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
a cell reference in a 3d reference | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |