Previous Topic Next Topic

Display a new entry in a column in a separate cell in excel

Closed
vivek - Oct 2, 2015 at 10:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Oct 5, 2015 at 11:54 AM
Hello,

I am having a column;

A B

1 ab
2 abc
3 abcd
4 abcde
5 xyz
6

I want the next entry in 6 row of A to be entered into 1 row of B and likewise any next entry in column A should be displayed in 1 row of B.

Please help me with this!

Thanks.
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Oct 5, 2015 at 11:54 AM
Hi Vivek,

Well, if you want your value not in A6 but in B1, then select B1 before entering your data.

Don't see the issue here.

Best regards,
Trowa

Similar discussions

If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses