Excel - 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

  Bernard Liengme replied to kevcar40

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 replied to Bernard Liengme

On 17 Mar, 13:15, "Bernard Liengme" <blien...@TRUENORTH.stfx.ca>
Thank you very much

Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB editor in Excel 2003 and in Excel 2002

Aggiornamento - Microsoft Risponde all’evoluzione delle Community Excel Cosa accade? Per informarvi che Microsoft comincerà presto a chiudere I newsgroup e a “transitare”, pian piano, se lo vorrete, il traffico sui Forum Microsoft. Perchè? Come ben sapete, i newsgroup sono esistiti per molti anni; il problema però è newsgroup. E’ possibile trovare informazioni su come installare e configurare il bridge qui: http: / / connect.microsoft.com / MicrosoftForums / Perchè i newsgroup verranno chiusi? Tutti i newsgroup pubblici verranno chiusi tra il la chiusura dei newsgroup, dove posso andare online per continuare le discussioni e ricevere supporto? Microsoft vi fornisce un’ampia scelta di forum, alcuni dei quali coprono lo stesso argomento od ottimale per continuare le discussioni online. Raccomandiamo quindi di cominciare con il http: / / social.answers.microsoft.com / Forums / it-IT / officeexcelit forum Vi invitiamo comunque a visitare i Forum Microsoft: http: / / www.microsoft.com / communities / forums / default.mspx Se ho domande, chi devo contattare? Se

Simplification code Excel Bonjour ? tous, Comment puis-je simplifier ce code avec des boucles ? Merci d'avance pour votre aide ! '- - Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = [a15].Address Then Rows("16:1400").Sort Key1: = [a1], Key2: = [b1], Key3: = [e1] ActiveWindow.ScrollRow = 15 End If If Target.Address = [b15].Address Then Rows("16:1400").Sort Key1: = [b1] ActiveWindow.ScrollRow = 15 End If If Target.Address = [c15].Address Then Rows("16:1400").Sort Key1: = [C1] ActiveWindow.ScrollRow = 15 End If If Target.Address = [d15].Address Then Rows("16:1400").Sort Key1: = [D1] ActiveWindow.ScrollRow = 15 End If If

Erinnerung - Microsoft reagiert auf Evolution der Community Excel Microsoft Office betrachtet Community als Teil des neuen Office 2010 Wie Sie wissen ist das Jahr 2010 ein wichtiges Jahr f?r Microsoft. Die neue Office-Version kommt auf den Markt. Office 2010 soll Ihnen das Leben und Hersteller beim Kauf eines neuen PCs erwerben. Ihre gew?nschte Version ist auch direkt von Microsoft erh?ltlich. Durch eine neue Methode zur Softwarebereitstellung mit dem Namen ?Click-To-Run? gelingt individuell! Worum geht es? Diese Nachricht dient dem Zweck, Sie dar?ber zu informieren, dass Microsoft demn?chst die Newsgroups abstellen und die Nutzer auf die Microsoft Foren verweisen wird. Warum? Wie Sie vielleicht wissen, gibt es Newsgroups schon seit einigen Jahren doch ist die Nutzung der Microsoft Newsgroups seit Jahren stetig zur?ckgegangen, da Kunden und Teilnehmer vermehrt L?sungen in den

Statistiche newsgroup m.p.i.o.e. Excel Per la prima volta da Luglio 2003, questo mese i post su *nostro* ng si attesteranno sotto a quota 1.000. Ricordo che qui: http: / / groups.google.it / group / microsoft.public.it.office.excel / about potete trovare le statistiche relative al *nostro* ng. Il calo del traffico è *male i *cugini* Access e Word e per il *papà* Office: http: / / groups.google.it / group / microsoft.public.it.office.access / about http: / / groups.google.it / group / microsoft.public.it.office.word / about http: / / groups.google.it / group / microsoft.public.it.office / about - - - -- -- -- -- -- -- -- -- -- -- -- -- -- Mauro Gamberini Microsoft MVP Excel http: / / www.riolab.org / http: / / www.maurogsc.eu / http: / / social.answers.microsoft.com / Forums / it