counting rows

I have a dynamic spreadsheet that updates values based on the year selected in a drop down on worksheet Summary and my data is in Table13 on worksheet Data. I'm trying to figure out how to count the number of rows within the date but skip duplicates...

Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...

Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...

hi, I have SAP file and I`m counting number of row in one order, example: <tbody> A 1 1 1 B 1 1 C 1 1 1 </tbody> I have code: For i = 2 To lastrow If SAP_WS.Range("A" & i).Value <> "" Then...

I really need help, someone please help me new to VBA So my user intrface asks user to select start and end date based on that my DATA sheet is updated and only shows those within the range , now i have another column in that filltered range and i need to count total number of DATES that are...

Hi i have xl file that contains a two tables of data. (see below) One table contains the names of some datahubs and the other contains sites that connects to the hubs. Wat i would like to do is to Count the number of sites each datahub has and store that value so it could be reused for other...

Thanks for reading this. I have a spreadsheet column called GroupNumber (1,2,3..). Each group can have from 2 to 35 rows of data. (Group 1 - 4 rows; group 2 = 16 rows, etc. The amount of rows I need to process can be any number from 100 to 1000 or more. Currently I have to do the update...

Hello all :) I'm a long-time reader of these boards, they have given me a lot of help and tips in the past and kept me in a job on more than one occasion. :) I'm now stuck on a spreadsheet in which I am trying to analyse a large amount of data using formulas, and none of the suggested...