Member Avatar for DAS-03590

I am looking for a way to use MS 2003 Excel with dropdown menus to display a list of information.
I have one year of data collected and am looking to have it setup to display a sected month's collected data by day. If possible could this compile a table in excel so that i only see the month selected?

Edited by DAS-03590
  • 2 Contributors
  • 2 Replies
  • 129 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by DAS-03590

Dani AI

Generated

A focused, no-macro method for Excel 2003 is to add a month selector (data‑validation dropdown), mark matching rows with a small helper column, then pull those rows into a compact report area. This keeps the workbook simple and fast; 's tutorial is useful for dropdown basics, and the steps below show how to build the month-only table that originally wanted.

Assume raw data on a sheet named Data with dates in A2:A1000. On a Report sheet place a month selector in B1 (Data > Validation; a simple list of 1,2,...,12 works). On Data add a month number helper in C2:

=MONTH(A2)

and a sequence column in D2 to number rows that match the selected month:

=IF($C2=Report!$B$1,COUNTIF($C$2:C2,Report!$B$1),"")

Fill both down to the end of the data. On Report, build the output table starting at row 3. To return the date for the nth matching row (first result = row 3), use:

=IF(ISERROR(MATCH(ROW(A1),Data!$D$2:$D$1000,0)),"",INDEX(Data!$A$2:$A$1000,MATCH(ROW(A1),Data!$D$2:$D$1000,0)))

Copy that formula down for subsequent rows; use the same MATCH to INDEX other columns (change Data!$A$2:$A$1000 to the desired column).

Notes and troubleshooting: ensure dates in Data!A are real Excel dates (Text to Columns or DATEVALUE can fix text dates). If the dropdown uses month names instead of numbers, convert with MONTH(DATEVALUE("1 "&Report!$B$1)). Avoid whole-column references in Excel 2003 for performance; adjust the 1000 to the actual data range or use named ranges. An alternative is an INDEX/SMALL array formula (Ctrl+Shift+Enter) or a PivotTable grouped by month/day if aggregation is acceptable.

Recommended Answers

All 2 Replies

Member Avatar for Member #952511

Have a look at this tutorial,
It's using Excel 2003, as well.

Member Avatar for DAS-03590

Well, I was looking into this, but I see it seems to not be able to do what I had originally intended. But It has been useful in a few other places. Thank you for the link.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.