Freeze the cell by pressing F4 once, it wil give you "$" symbol along with
the cell adress
On Fri, Jan 25, 2013 at 5:26 PM, Sadia Khalid wrote:
> SALAM
> Hi Every one Hope that all of you are fine.
>
> How i can use this formula to have the absolute cell address.
> =(ADDRESS(ROW()-1,COLUMN()))
>
SALAM
Hi Every one Hope that all of you are fine.
How i can use this formula to have the absolute cell address.
=(ADDRESS(ROW()-1,COLUMN()))
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread ti
The "ROW()-8" in the formula should be changed to "ROW()-10" since I
guess your comment offset the results by 2 rows!
On Feb 20, 1:05 pm, Christopher Luka
wrote:
> Here's an example with one way to do it. Let me know if the formula is too
> complex & I'll walk you thru it.
>
--
---
Hi Christopher Luka,
This is really great. For my understanding can you please explain this
offset function step by step so that I can also understand your logic.
Thanks,
Deepak
On Tue, Feb 23, 2010 at 10:09 AM, Maitre Bart wrote:
>
>
> On Feb 20, 12:05 pm, Christopher Luka
> wrote:
> > Here'
On Feb 20, 12:05 pm, Christopher Luka
wrote:
> Here's an example with one way to do it. Let me know if the formula is too
> complex & I'll walk you thru it.
> [...]
Interesting! It looks like what I need. I will give a try on my
spreadsheet.
Thank you both for your offers.
--
---
Here's an example with one way to do it. Let me know if the formula is too
complex & I'll walk you thru it.
On Wed, Feb 17, 2010 at 10:49 AM, Maitre Bart wrote:
> Hi,
>
> I have some source data in one sheet (Calculations) and formatted data
> in a second sheet (Output).
>
> In the Calculations
may be there is some cell reference problem
attach ur file
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Feb 18, 2010 at 12:19 AM, Maitre Bart wrote:
> Hi,
>
> I have some source data in one sheet (Calculations
Hi,
I have some source data in one sheet (Calculations) and formatted data
in a second sheet (Output).
In the Calculations sheet, data are one organized one row after the
other.
In the Output sheet, data are grouped by 5 lines, referencing data in
Calculations.
So one every 5 lines in Output ref
