Formula to filter data

Hello,

is there a formula that is equivalent to the filter function?

Example:
In my case I have a sheet with a lot of data, and in one column the machine number is given. However, there can be several rows with the same machine number.
Now I need every single machine number just once transferred into a new table sheet. Meaning, to create an overview of all the machines that are in that data sheet.
I cannot use VLOOKUP because I do not know all the machine numbers.
I cannot use PivotTable either because I am only allowed to program the excel table with formulas.
Here is a picture of the data I need to sort:
23-11-_2016_11-50-03.png

And here in this column in another sheet I need every machine number once:
23-11-_2016_12-08-13.png


Thank you for any help!!

Appreciate it!

Regards

Many contributors (including me) are not able to view .png files on this forum due to software incompatibilities with some browsers. Besides, you can't try out different formulae in picture files, so it would be better if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

Right, thank you for the description how to upload a file. If I did it right, it should be attached now.

Thank you for that formula! I transferred it and it worked, thank you.
However, if I want to enter a whole column for the range, it returns wrong values.
In your example:
G6=IFERROR(INDEX(F:F,MATCH(0,INDEX(COUNTIF($G$5:G5,F:F),),0)),"")

Is there a way to include the whole column? (For now, I put F2:F9999 to have sufficient range, but safer would be the whole column in case that the original data changes)

I have headings in row 1 and the data starts in row 2.

True, I'll just change it to such a big number that the probability of inaccurancy would almost be equal zero.

Thank you very much! It helped me a lot!