What do I need to do here please.
 

Hello from Steved

I've have two worksheets named Summary and City (1)

ok the below will give me the first numeric number off 1721 which is 1
Which is in the Summary Sheet.

=IF(1-ISERROR(F6),IF(ISNUMBER(--LEFT(F6)),--LEFT(F6),LEFT(F6)),"")

ok in Sheet named City (1) I have =IF(Summary!A6=1,ROW(),"")

I want to take out
=IF(1-ISERROR(F6),IF(ISNUMBER(--LEFT(F6)),--LEFT(F6),LEFT(F6)),"") from the
summary sheet and put it in City (1)

ok this is my attempt
=IF(1-ISERROR(Summary!F6),IF(ISNUMBER(--LEFT(Summary!F6)),--LEFT(Summary!F6),LEFT(Summary!F6)),"")*IF(Summary! F6=1,ROW(),"")

It is displaying #VALUE! I am asking it to read from Cell F6 on the sheet
Called Summary.

Please Help Thankyou.

Hello from Steved

in the first column I've put =IF(R6=1,ROW(),"")

At the end In Column R I've put
=IF(1-ISERROR(Summary!F6),IF(ISNUMBER(--LEFT(Summary!F6)),--LEFT(Summary!F6),LEFT(Summary!F6)),"")

And it works fine

Ok can I combine the both together please.

Thankyou.

"Steved" wrote:

Hello from Steved

I've have two worksheets named Summary and City (1)

ok the below will give me the first numeric number off 1721 which is 1
Which is in the Summary Sheet.

=IF(1-ISERROR(F6),IF(ISNUMBER(--LEFT(F6)),--LEFT(F6),LEFT(F6)),"")

ok in Sheet named City (1) I have =IF(Summary!A6=1,ROW(),"")

I want to take out
=IF(1-ISERROR(F6),IF(ISNUMBER(--LEFT(F6)),--LEFT(F6),LEFT(F6)),"") from the
summary sheet and put it in City (1)

ok this is my attempt
=IF(1-ISERROR(Summary!F6),IF(ISNUMBER(--LEFT(Summary!F6)),--LEFT(Summary!F6),LEFT(Summary!F6)),"")*IF(Summary! F6=1,ROW(),"")

It is displaying #VALUE! I am asking it to read from Cell F6 on the sheet
Called Summary.

Please Help Thankyou.