Ask.Formula result as any address

**daboho** · 10-21-2018, 04:29 AM

I want formula
If(a1:a1000="man",row(a1:a1000))
If in formula using F9
Result ={1,2,3,false,false,etc}
How to change to address
Result using F9 ={a1,a2,a3,false,false,etc}

If(a1:a1000="man",row(a1:a1000))
How change row become address

**rorya** · 10-21-2018, 06:03 AM

Just prefix the column letter:

Please Login or Register  to view this content.

**jason.b75** · 10-21-2018, 06:04 AM

With the address function, but I somehow doubt that what you ask for is what you will actaully need.

What do you want to do with that cell address next?

**daboho** · 10-21-2018, 09:54 AM

Originally Posted by jason.b75

With the address function, but I somehow doubt that what you ask for is what you will actaully need.

What do you want to do with that cell address next?

I want to input to vba filter

**daboho** · 10-21-2018, 09:55 AM

Originally Posted by rorya

Just prefix the column letter:

Please Login or Register  to view this content.

I hope this run thankyou royra

**daboho** · 10-21-2018, 12:32 PM

Originally Posted by rorya

Just prefix the column letter:

Please Login or Register  to view this content.

Thank very match royra this case is SOLVED

**rorya** · 10-22-2018, 01:53 AM

Please mark it accordingly.

Ask.Formula result as any address

LinkBack

Thread Tools

Rate This Thread

Display

Ask.Formula result as any address

Re: Ask.Formula result as any address

Re: Ask.Formula result as any address

Re: Ask.Formula result as any address

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to go to a Cell Address which is the result of a formula

[SOLVED] Replacing cell address in a formula with the result of ADDRESS function

[SOLVED] Need help to correct an ADDRESS & MATCH formula for Hyperlinking hlookup result

[SOLVED] Use TEXT Address result in user defined formula as Range

[SOLVED] Return Cell Address of the min() formula result

[SOLVED] How can I use the result from ADDRESS in another formula

[SOLVED] Using Address Result

Bookmarks

Bookmarks

Posting Permissions