Duplicate values at the bottom, not at the top
Closed
jutulu
Posts
34
Registration date
Monday 10 March 2014
Status
Member
Last seen
21 September 2015
-
1 Apr 2014 à 13:57
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 14 Apr 2014 à 10:09
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 14 Apr 2014 à 10:09
Related:
- Duplicate values at the bottom, not at the top
- Outlook duplicate items remover (odir) - Download - Email
- Based on the values in cells b77 - Excel Forum
- How to duplicate data from one excel sheet to another ✓ - Excel Forum
- How to duplicate a google doc - Guide
- Copy data from one Excel sheet to another: automatically - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
8 Apr 2014 à 10:53
8 Apr 2014 à 10:53
Hi Jutulu,
The result is located where the formula is located.
So change the location of the formula to change the location of the result.
Best regards,
Trowa
The result is located where the formula is located.
So change the location of the formula to change the location of the result.
Best regards,
Trowa
jutulu
Posts
34
Registration date
Monday 10 March 2014
Status
Member
Last seen
21 September 2015
2
8 Apr 2014 à 17:34
8 Apr 2014 à 17:34
Thanks Trowa,
Can you please explain it a bit further? I thought of it before I send it and indeed changed the order of the formula, but no success. In my mind, my little knowledge, the last ),""), should avoid a false statement.
Can you please explain it a bit further? I thought of it before I send it and indeed changed the order of the formula, but no success. In my mind, my little knowledge, the last ),""), should avoid a false statement.
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
14 Apr 2014 à 10:09
14 Apr 2014 à 10:09
Hi Jutulu,
I guess we are talking about different things.
What I meant was when you have a data range of A2:A10 and you have your formula in A1 then result will be on top. If you place your formula in A11 your result will be at the bottom.
Technically you are not avoiding the false statement with "". You are basically saying if the statement is false then input nothing.
Not sure what you are trying to achieve. Maybe post some sample data and explain what you want to do with it, along with result sample data.
Best regards,
Trowa
I guess we are talking about different things.
What I meant was when you have a data range of A2:A10 and you have your formula in A1 then result will be on top. If you place your formula in A11 your result will be at the bottom.
Technically you are not avoiding the false statement with "". You are basically saying if the statement is false then input nothing.
Not sure what you are trying to achieve. Maybe post some sample data and explain what you want to do with it, along with result sample data.
Best regards,
Trowa
