Ask Your Question

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? [closed]

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-11 23:08:00.988135


why is the data spread over multiple Sheets ??

karolus gravatar imagekarolus ( 2015-05-20 00:46:09 +0100 )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 +0100 )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 +0100 )edit

1 Answer

Sort by » oldest newest most voted

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

JohnSUN gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 3,100 times

Last updated: May 26 '15