Ask Your Question
0

is there a function that can count unique values within a specific column accross multiple tabs in a spreadsheet and also count how many of each unique value there are?

asked 2015-05-19 22:58:47 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have multiple tabs in one sheet of clients and would like to find some way to count each unique item ( instance of a client name) from multiple tabs in a spread sheet. Also would like to be able to count how many of each unite client name there are. Further if it is possible to also have these results sorted by tab name and totaled would be awesome. If this is possible in libre office great, if not, I would simply love to know if there is a possibility for this and how to achieve it. This way I could know how many times any unique client name appears in the whole sheet, how many times in each individual tab and which one.

edit retag flag offensive close merge delete

Comments

why is the data spread over multiple Sheets ??

karolus gravatar imagekarolus ( 2015-05-20 00:46:09 +0200 )edit

I agree with @karolus, there has to be a really heavy reason why spread the data, you have over 1 million cells to use globally after all. Without something like a database backup in form of CSV/TSV you can't just get that used that easily. In contrast, Google Sheets (new version) supports about 2 million cells globally.

rautamiekka gravatar imagerautamiekka ( 2015-05-20 00:50:44 +0200 )edit

Excuse my bad English. I did not understand the phrase "multiple tabs in one sheet" Did you mean "multiple tabs (sheets) in one workbook?"

JohnSUN gravatar imageJohnSUN ( 2015-05-20 08:05:41 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2015-05-26 13:03:00 +0200

JohnSUN gravatar image

Yes, such a function present at now. Try this example - CreateTableOfContents.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-05-19 22:58:47 +0200

Seen: 2,784 times

Last updated: May 26 '15