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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:51 PM.