Hi,
Can anyboby help me out.I need to filter start & finish dates from two column with same criteria.
Please find attached sheet,I need starting & finishing item in a range from 1 Jan 18 to 15 Jan 18.
Hi,
Can anyboby help me out.I need to filter start & finish dates from two column with same criteria.
Please find attached sheet,I need starting & finishing item in a range from 1 Jan 18 to 15 Jan 18.
I don't understand your request. Can't you just autofilter.
Hi,
This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.
Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Based upon data shown, what should the end result look like. Not sure I understand your needs.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
In a simple way I need to sort items falling in range 1 Jan 18 to 15 Jan 18.
Some Item start date will fall in this range & some item finish dates.
When filter start date I dont want to bother finish date & vice versa.
Please provide a sample of your expected output as requested by both Richard and me. Your new explanation is no clearer in visualizing what you want than your first explanation.
Data
Item Start Finish
A 1-Jan-18 15-Jan-18
B 8-Jan-18 17-Jan-18
C 15-Feb-18 28-Feb-18
D 10-Jan-18 15-Feb-18
E 1-Jan-18 30-Jan-18
F 15-Dec-17 10-Jan-18
Expected Result
A 1-Jan-18 15-Jan-18
B 8-Jan-18 17-Jan-18
D 10-Jan-18 15-Feb-18
E 1-Jan-18 30-Jan-18
F 15-Dec-17 10-Jan-18
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks