Hello Friends,
We often get such a situation when we have to reverse the content of the columns or rows. I have created a formula for it that can save your lot of copy-paste time.
I have entered the name of the day in column A (A1 to A7, the entry must be non-blank) in my example. Put the following formula in any cell and drag down as far as you need (you'll get a zero when there are no more entries).
We often get such a situation when we have to reverse the content of the columns or rows. I have created a formula for it that can save your lot of copy-paste time.
I have entered the name of the day in column A (A1 to A7, the entry must be non-blank) in my example. Put the following formula in any cell and drag down as far as you need (you'll get a zero when there are no more entries).
Similarly, we can reverse the ROW data by using the following formula (data enter in row 1)=(INDEX(A:A,COUNTA(A:A)-ROW(A1)+1)
You can edit the formula by changing the column and row number. Some Screenshots are posted below.=INDEX(1:1,COUNTA(1:1)-COLUMN(A1)+1)
No comments:
Post a Comment