solid

Good evening I have a sample of data below. I have about 200,000 rows. I am looking for a formula or subroutine that will find the school month and calculate the frequency like below. Here is an example I would like to check Lincoln School in the SEPT column and count how many cells are 1 to 4...

Hi all,<o:p></o:p> <o:p> </o:p> I am a novice at excel and not sure if it’s possible formy idea to work.<o:p></o:p> <o:p> </o:p> I want to create a sheet which tells me the total numberof staff I have on duty during the day. With times every half hour from 0700 to2230. <o:p></o:p> When I put...

Good afternoon, I have data based on 2 columns column B and E. What I would like to do is to highlight the group in yellow if the name and the DOB match. For instance AAAA and DDDD would be highlighted in this example. Thanks in advance!!!!! <style type="text/css"> table.tableizer-table {...

Dear All, I have a worksheet like this- <tbody> TYPE NAME A Rachell Rivard A Fatimah Tay A Zane Crowley A Hermine Elsner B Leigh Ortez B Priscilla Michie B Ken Cardiel B Mack Zheng C Ruthe Lanz C Neida Gallivan C Sherry Barrientez C Sondra Schrage </tbody> Now, I...