Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function problem with iPhone/Pad compatibilty
Hi
I have a spreadsheet that I have tried transferring to iPhone/iPad, but it seems to have an incompatible function that the i-Series moan about. I want to use the sheet, which is a sports score card, at meets. I wondered if anyone has experience of utilising sheets on iPhones or iPads that could help This is one of the Formulae that fails: =MATCH($Z1,INDIRECT(ADDRESS(AA1+1,23,4)):$W$61,0)+ AA1 I beleive it is the 'ADDRESS' function that isn't working. This is looking at the data in Z1 and checking for it's occurence in a column. In my example, this is in Cell AB1 it is looking for the 2nd occurence of the data in Z1, Cell AC1 looks for the 3rd occurence, and so on up to the 7th occurence So, I'm looking for suggestions please, for another (iPhone compatible!!) way to look these up Any help most gratefully received. Please let me know if you need more information Thanks Neil |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function problem with iPhone/Pad compatibilty
On Mar 18, 2:16*pm, "
wrote: Hi I have a spreadsheet that I have tried transferring to iPhone/iPad, but it seems to have an incompatible function that the i-Series moan about. I want to use the sheet, which is a sports score card, at meets. I wondered if anyone has experience of utilising sheets on iPhones or iPads that could help This is one of the Formulae that fails: =MATCH($Z1,INDIRECT(ADDRESS(AA1+1,23,4)):$W$61,0)+ AA1 I beleive it is the 'ADDRESS' function that isn't working. This is looking at the data in Z1 and checking for it's occurence in a column. In my example, this is in Cell AB1 it is looking for the 2nd occurence of the data in Z1, Cell AC1 looks for the 3rd occurence, and so on up to the 7th occurence So, I'm looking for suggestions please, for another (iPhone compatible!!) way to look these up Any help most gratefully received. Please let me know if you need more information Thanks Neil Just read that INDIRECT doesn't work either? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving excel files in compatibilty mode | Excel Discussion (Misc queries) | |||
Excel file in compatibilty mode and not all sheets within the fil. | Excel Worksheet Functions | |||
compatibilty mode document does not print clearly | New Users to Excel | |||
Excel 2007 Macros compatibilty with earlier versions!! | Excel Discussion (Misc queries) | |||
English date format and compatibilty with others Excel Language | Excel Discussion (Misc queries) |