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.