row numbering

maybe adjust it to =IF(B8="";"";COUNTA(B8:$B$8))

It works for me because as soon as I hit enable editing all your content in B through K goes away because it is externally linked.
So I copied and pasted over the output in those cells and now they are all blank and if I use that formula the numbering goes away.
When I put a formula in B8 that looks for anything in another cell and returns a blank if it is empty the numbering is still gone from col A.
So I'm unable to repeat your results.

I can't open your workbook from either work or home without the linked cells going blank. If you could take the data in those cells in B8 through K12 and copy >> paste special >> values then I (or others) might be able to see why that formula isn't working. Because even for my iMac version of excel that formula works for me.

Originally Posted by drogar

it still numbers the row, because it sees zero as a value !

Sambo kid's formula works fine, I don't see any problem:

	A	B	C
5	Search result
6
7	Nr.	Surname and name	Welder nr.
8
9

	A	B	C
5	Search result
6
7	Nr.	Surname and name	Welder nr.
8	=IF(B8="","",COUNTA(B8:$B$8))	=IFERROR(_xlfn._xlws.FILTER('Data input'!B2:K21,('Data input'!B2:B21=Search!B2)+('Data input'!C2:C21=Search!C2)+('Data input'!D2:D21=Search!D2)+('Data input'!E2:E21=Search!E2)+('Data input'!F2:F21=Search!F2)+('Data input'!G2:G21=Search!G2)+('Data input'!H2:H21=Search!H2)),"")	=IFERROR(_xlfn._xlws.FILTER('Data input'!B2:K21,('Data input'!B2:B21=Search!B2)+('Data input'!C2:C21=Search!C2)+('Data input'!D2:D21=Search!D2)+('Data input'!E2:E21=Search!E2)+('Data input'!F2:F21=Search!F2)+('Data input'!G2:G21=Search!G2)+('Data input'!H2:H21=Search!H2)),"")
9	=IF(B9="","",COUNTA(B$8:$B9))	=IFERROR(_xlfn._xlws.FILTER('Data input'!B2:K21,('Data input'!B2:B21=Search!B2)+('Data input'!C2:C21=Search!C2)+('Data input'!D2:D21=Search!D2)+('Data input'!E2:E21=Search!E2)+('Data input'!F2:F21=Search!F2)+('Data input'!G2:G21=Search!G2)+('Data input'!H2:H21=Search!H2)),"")	=IFERROR(_xlfn._xlws.FILTER('Data input'!B2:K21,('Data input'!B2:B21=Search!B2)+('Data input'!C2:C21=Search!C2)+('Data input'!D2:D21=Search!D2)+('Data input'!E2:E21=Search!E2)+('Data input'!F2:F21=Search!F2)+('Data input'!G2:G21=Search!G2)+('Data input'!H2:H21=Search!H2)),"")

Sheet: Search

clicking on both of your attachments I get the message that they are invalid links.

https://jumboiskon.tportal.hr/dl/5e7...0-85ca4f40aaa9
https://jumboiskon.tportal.hr/dl/243...d-f4434e8617d3

try now please

Could you explain what it is exactly that you are trying to do? Your two snapshots are not helpful.

According to Microsoft See here..... the Filter function is a new one still under beta testing. Personally I'd wait until it's been signed off.

What you seem to want is to extract stuff from the Data Input sheet onto the Search sheet for the various names. In which case surely a simple VLOOKUP() would suffice?

If not then the new Filter() function seems to be similar to the 'D' Database series of functions, e.g. =DGET(), =DSUM() ..etc.

If you would manually add some results and indicate where they are then maybe this will become clearer.

Sheet Data input
- B2:K21, different data entered in cells.

Sheet Search
- input multiple search criteria B2:K2 (acc to information in sheet Data input cells B2:K21)
- search results output B8:K23
- if nothing is found, search result is zero (disabled in options/advance : "Show a zero in cells that have zero value", so they are hidden)
- this search works fine, but what I need
- A8:A23 automatic row numbering, if something is in row 8, cells B8:K8, put 1 in cell A8
- if something is in row 9, cells B9:K9, put 2 in cell A9
- if something is in row 10, cells B10:K10, put 3 in cell A10, etc....
- if zero (hidden) in a row 11, do not put the number 4 in the following row, etc...

Have you considered my suggestion in post #6 where you upload another example workbook where the columns with your linked formulas that don't come through, copy those and paste special the values (including those that are blank) so we can test out other formulas to see what will work?

Originally Posted by drogar

Thank you for your suggestion for using VLOOKUP. I've google it, but I think it is not what I need.
Problem is that I want to output data left and right from the searched criteria.
VLOOKUP searches according to one criteria in a range, FILTER is multiple criteria.

My problem is row numbering

The usual solution to a LOOKUP where VLOOKUP won't work because of columns being left & right of the searcged column field is to use an =INDEX(MATCH()) compound formula.

the workbook you uploaded in post #1, when I open it I get the warning at the top (which I assume most members here get) that says protected view, be careful... and it gives me an "Enable Editing" button I can click to allow me to try to write formulas as a test in it. When I click on enable editing all the values I see in cells B8 through K11 disappear so any formula I have tried to write for you works for me. That is why I asked you to copy the values in All those rows and columns (even the blank ones) then paste special >> values so I can better see how to write a formula that might work. I cannot do that because as I noted, as soon as I click enable editing the values disappear.