Question description:
This user has given permission to use the problem statement for this
blog.
i have a spread sheet , where i have row names a , b ,c
and i have column names d, e, f, , , , , , in the table if i enter one , i want to get column name and row name , d a , e, b , f, c
Solved by E. S. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
10/04/2018 - 05:40
hi
User
10/04/2018 - 05:40
sir
Excelchat Expert
10/04/2018 - 05:40
Hi there
User
10/04/2018 - 05:40
sir are you able to see my sheet that i enter value
Excelchat Expert
10/04/2018 - 05:41
Yep
User
10/04/2018 - 05:41
ok sir , i want to get the result in another sheet , but my result should be like this ,
User
10/04/2018 - 05:41
the sheet
User
10/04/2018 - 05:42
if i enter 1 i want to get column name and row name
User
10/04/2018 - 05:42
you seen
Excelchat Expert
10/04/2018 - 05:43
yep
User
10/04/2018 - 05:43
if i enter value one or any letter depends on my task, i want to get row and column name
Excelchat Expert
10/04/2018 - 05:44
we can get column name as A, B, C and row name as 1,2,3
Excelchat Expert
10/04/2018 - 05:45
like you entered 1 we can get the output as C3
User
10/04/2018 - 05:45
c3 is the location of cell
Excelchat Expert
10/04/2018 - 05:45
yep
User
10/04/2018 - 05:45
i want to get the name
User
10/04/2018 - 05:45
b 22
Excelchat Expert
10/04/2018 - 05:46
getting the name like that is not possible in excel, as excel treat them as values in a cell location only
User
10/04/2018 - 05:47
ok according to you its not possible , but but is there is any option , to assign c3 location name as b22
Excelchat Expert
10/04/2018 - 05:49
This can be done using a VBA code/Macro
User
10/04/2018 - 05:49
ok ok ,, another question sir ,, if i have data see sheeet , i want only those name whose vlaue is this
Excelchat Expert
10/04/2018 - 05:50
Okay
Excelchat Expert
10/04/2018 - 05:52
Okay means by looking the alphabets you need to get the numbers right?
User
10/04/2018 - 05:52
i want to skip 0 value names
User
10/04/2018 - 05:53
only want to display those cells who has value
Excelchat Expert
10/04/2018 - 05:53
yah, got it
User
10/04/2018 - 05:54
any rule or formulla
Excelchat Expert
10/04/2018 - 05:54
Check there i have given you the formula :)
Excelchat Expert
10/04/2018 - 05:55
Is it nice
User
10/04/2018 - 05:55
i enter more data
User
10/04/2018 - 05:56
not displaying
Excelchat Expert
10/04/2018 - 05:56
put the alpabhets also in column D
User
10/04/2018 - 05:57
yes thanks
User
10/04/2018 - 05:57
sir
Excelchat Expert
10/04/2018 - 05:57
Please do a valuable rating for me
Excelchat Expert
10/04/2018 - 05:57
that will help me a lot
User
10/04/2018 - 05:57
sir can you mail me at shahidhost@gmail.com
Excelchat Expert
10/04/2018 - 05:57
If you really like it please put up some good words for me clicking "Others"
User
10/04/2018 - 05:57
ith vba macro code
Excelchat Expert
10/04/2018 - 05:57
You can download this
User
10/04/2018 - 05:58
i am new here , i will do what ever screen show me
User
10/04/2018 - 05:58
thanks sir
Excelchat Expert
10/04/2018 - 05:58
Yep
Excelchat Expert
10/04/2018 - 05:58
Thanks for being in Got it Pro!
Excelchat Expert
10/04/2018 - 05:58
Have a nice day!
User
10/04/2018 - 05:58
sir can you mail me
User
10/04/2018 - 05:59
for more help in future
User
10/04/2018 - 05:59
please
User
10/04/2018 - 05:59
shahidhost@gmail.com
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.