App script to get the Unique Data & Count

[Shubham Gupta]

Hi There,

I want to get the Unique Type(Column C), No of Occurrence, and number of unique document code w.r.t Type in the Answer tab based on Data tab.

https://docs.google.com/spreadsheets/d/1MZiqoKHjcjAJsvMz0bEEfke_GE54wyOcMIXa3jd5GBU/edit#gid=970494399

[Laurie J. Nason]

Dear Shubham,

It seems that you might not need any code at all to do this. Just a combination of filter - for the unique values you want to count up, then use the result of that to do some county/countifs for each row to get the numbers you want to see.

Laurie

------ Original Message ------

From "Shubham Gupta" <shubham...@gmail.com>

To "Google Apps Script Community" <google-apps-sc...@googlegroups.com>

Date 26/09/2022 22:05:50

Subject [Apps-Script] App script to get the Unique Data & Count

Hi There,

I want to get the Unique Type(Column C), No of Occurrence, and number of unique document code w.r.t Type in the Answer tab based on Data tab.

https://docs.google.com/spreadsheets/d/1MZiqoKHjcjAJsvMz0bEEfke_GE54wyOcMIXa3jd5GBU/edit#gid=970494399

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/4ecb8def-bc7b-4f15-9f1a-f0e1f8cfa6c5n%40googlegroups.com.