is there a fast way to match my "cell content" to the "row number"

[sophiekabu]

is there a fast way to match my "cell content" to the "row number" ​

Hello guys,
please help me
is there a fast way to match my "cell content" to the "row number"? TT_TT[IMG alt="thumbnail image 1 of blog post titled











is there a fast way to match my cell content to the row number












"]https://techcommunity.microsoft.com...EC7F13D3EE/image-size/large?v=v2&px=999[/IMG]

Ex: the ones with the yellow Highlight
my "cell content" 326 matches with the "row number" 326
my cell content 337, matches with the row number 337

I want to do the same thing with cell contents 350, 353, 361, 365, 372, 380, 385, 389, 397, 402, 409 and 411

PLEASE HELP ME

 

[sophiekabu]

this is the picture

 

[RoryA]

You can use MATCH for that since it returns the position:

=match(350,A:A,0)

for example.

 

[sophiekabu]

it doesn't work, but thank you so much Rory

I really want to make my life easy, but I don't know how I'm going to do it. What I do is I do it "manually", I highlight then insert cells down until it reaches the corresponding row number ~it's tiresome and it's eating up my time too much

 

[nageswararao]

I could not understand the reason for MATCH function not being suited for your thread

 

[nageswararao]

I could not understand the reason for MATCH function not being suited for your thread

 

[RoryA]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Also cross posted at:

Is there a fast way to match my "cell content" to the "row number"

Is there a fast way to match my "cell content" to the "row number"? Ex: the ones with the yellow Highlight my "cell content" 326 matches with the "row number&quo...

stackoverflow.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[sophiekabu]

I could not understand the reason for MATCH function not being suited for your thread

what I want is to sort it easily where the cell number matches with the corresponding row number

so if my cell contains the number 15, I want it to be in row number 15 exactly

in my example, I want 350 to match with row number 350

 

[RoryA]

It wasn't at all clear to me that you need to move the content to the relevant row. (I also can't really imagine why, but that's another issue).

Is it actually just two columns of data you have currently?

 

[sophiekabu]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Also cross posted at:

Is there a fast way to match my "cell content" to the "row number"

Is there a fast way to match my "cell content" to the "row number"? Ex: the ones with the yellow Highlight my "cell content" 326 matches with the "row number&quo...

stackoverflow.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

okay, copy, thank you so muchhh


Also cross posted at:

is there a fast way to match my "cell content" to the "row number" | Microsoft Community Hub

Hello guys,please help me 😞is there a fast way to match my "cell content" to the "row number"? TT_TTEx: the ones with the yellow Highlightmy "cell content"...

techcommunity.microsoft.com