Excel shenanigans part 456.

[libero]

Greetings oh sages of excel and the Gennys.

Trying to figure out a way to count unique drawing/line numbers on a spreadsheet.Seems easy enough but the drawings are split up into different systems and sub systems and different areas.Have been using SUBPRODUCT(1/COUNTIF (A3:A25,A3:A25) This give me the amount of unique lines and works fine but how do I then get the unique system?? I can do a countif =COUNTIFS(A3:A25,"SYSTEM 123")to count the number of drawings in system in but the problem arises when I need to add in the drawing number again for additional work needing done meaning there is a duplicate I don't want to count.

[Nathan Explosion]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[libero]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Nathan Explosion]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[libero]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited November 2, 2015 by libero

[fred]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here