| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find cell value
hi
i have this formula that identifies the last column with data in it. =ADDRESS(35,MATCH(6.022*10^23,33:33)) this works a treat what i would like to do is us the result of this and subtract 3 column of it ie ADDRESS(35,MATCH(6.022*10^23,33:33)) = N35 i would like to have a formula that takes N35 and sub tracts 3 columns fro it giving K33 i then intend making that my range ie k12:n33 and copy the data else where to work on thanks kevin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find cell value
If =ADDRESS(35,MATCH(6.022*10^23,33:33)) returns $N$35
then =ADDRESS(35,MATCH(6.022*10^23,33:33)-3) will return $K$35 best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "kevcar40" wrote in message ... hi i have this formula that identifies the last column with data in it. =ADDRESS(35,MATCH(6.022*10^23,33:33)) this works a treat what i would like to do is us the result of this and subtract 3 column of it ie ADDRESS(35,MATCH(6.022*10^23,33:33)) = N35 i would like to have a formula that takes N35 and sub tracts 3 columns fro it giving K33 i then intend making that my range ie k12:n33 and copy the data else where to work on thanks kevin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find cell value
On 17 Mar, 13:15, "Bernard Liengme"
wrote: If * *=ADDRESS(35,MATCH(6.022*10^23,33:33)) * *returns $N$35 then =ADDRESS(35,MATCH(6.022*10^23,33:33)-3) will return $K$35 best wishes -- Bernard Liengme Microsoft Excel MVPhttp://people.stfx.ca/bliengme "kevcar40" wrote in message ... hi i have this formula that identifies the last column with data in it. =ADDRESS(35,MATCH(6.022*10^23,33:33)) this works a treat what i would like to do is us the result of this and subtract 3 column of it Thank you very much ie ADDRESS(35,MATCH(6.022*10^23,33:33)) * *= * N35 i would like to have a formula *that takes N35 and sub tracts 3 columns fro it giving *K33 i then intend making that my range ie k12:n33 and copy the data else where to work on thanks kevin- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Change the appearance cell where Find criteria is found in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
