Create detailed reports from a complex Excel spreadsheet.

Hi,

I'm new to this forum so apologies if this question is in the wrong section.

I have a spreadsheet that has approximately 70 columns and 25,000 rows. Each row is created from a submission to a webpage where the user answers multiple questions. The columns are a mix of dates, times, TRUE/FALSE, Numbers and Text. I need a solution that will enable me to create a report after entering various criteria, such as date range in a particular column, Number range in another, Text in another column, and whether TRUE or FALSE appears in another column. There might be up to 10 different criteria entered. What I'm hoping to find is that there is a program that I could use that I could "plug" my spreadsheet in to, create my own interface to extract the data and, voila, a report emerges. This might be wishful thinking, but maybe one of you gurus can point me in the right direction

Edit to this question;
I've attached a sample spreadsheet.

Some examples of the output I need are:
How many entries are there where Column CI = X AND date in column CG = Y (this criteria might be 2 consecutive dates)
How many times is the entry in column AB "TRUE" when column CI = X
What is the average number of entries between 2 times. Using the time stamp in column CH BUT ignoring the date portion. We want to measure output based upon shifts, which are 9:00AM to 5:00PM, 5:00PM to 11:00PM and 11:00PM to 9:00AM
Following on from the previous line, we then want to measure the average number of entries between 2 times when entry in column CI = X

I hope all that makes sense

Welcome to the forum.

Is it Excel 365 you have? Please update your profile with the product.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

That's not using Code. windknife's solution uses Excel 365 functions in a formula. To be fair, it's not the simplest formula to follow.

John and Pete use "old school" Excel formulae. They should be easy enough to relate to.

What do you mean by "more user friendly"?

If that's what you want, Google: software to produce report from Excel spreadsheet

There's loads of applications that purport to analyse data in Excel spreadsheets. How good they are, how much they cost, and if any of them meet your requirements, I do not know.