Data Analyze - Prompt to find data using month as range (i.e from January to May)

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Data Analyze - Prompt to find data using month as range (i.e from January to May)

FAQ

Thread Tools

Display Modes

06-24-2024, 12:41 AM

Alansidman Alansidman is offline

Windows 11 Data Analyze - Prompt to find data using month as range (i.e from January to May)

Office 2021

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 121

You could filter the year for 2017 or you could build a Pivot Table and filter for the year and product. It would be easier to demonstrate if you uploaded a sample file instead of picture. We cannot manipulate data in a picture.

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2511

Tags

data analyze, data prompt

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Data by month to table using Inputbox with Add or Delete Row	CemHyur	Excel Programming	9	11-19-2022 01:55 PM
Sort data by month and by dates	Marcia	Excel	4	05-30-2018 01:51 AM
Auto update excel graph range, ignore data when date reads 00-Month-00	SavGDK	Excel	2	06-24-2016 08:05 AM
floating month prompt	schroca	Word	2	05-12-2014 06:32 PM
Using data entered in prompt to search database table	BluRay	Word	1	03-25-2011 01:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:36 PM.