Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for a function to make it more quicker
in first column I have the data as:
=ABS($AK$9-B$9) =..................C$9) .. .. .. =ABS($AK$9-AJ$9) Now if for example above are in Column BD, now I want next set in BF as: =ABS($AK$10-B$10) =..................C$10) .. .. .. =ABS($AK$10-AJ$10) then again in BH as: =ABS($AK$11-B$11) =..................C$11) .. .. .. =ABS($AK$11-AJ$11) It goes for couple of more columns. How do I make it a bit quicker than what I do as copy paste, cut etc.. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get files to open quicker | Excel Discussion (Misc queries) | |||
Is there a shorter/quicker way to do this? | Excel Worksheet Functions | |||
Is there a quicker way to copy a rang abd its formatting this is 2 | Excel Discussion (Misc queries) | |||
Cell problems - need a quicker way. | Excel Worksheet Functions | |||
quicker entry of list rows | Excel Discussion (Misc queries) |