Lookup/Find value with multiple Criteria

Bugas

New Member
Joined
Sep 17, 2012
Messages
44
Office Version
  1. 2007
Platform
  1. Windows
I have a provider that I have to pay everymonth. Sometimes, twice a month. I need to know when I payed in a specific date.

AB
1XYZ
2
fev/23​
3
fev/23​
27/02/2023 16:02​
4
fev/23​
5
jan/23​
31/01/2023 16:00​
6
jan/23​
7
jan/23​
01/01/2023 15:00​
8
jan/23​
9
jan/23​
10
dez/22​
11
dez/22​
02/12/2022 14:00​
12
dez/22​


I want to get this Information:

AB
1fev/23
27/02/2023 16:02​
2jan/23
31/01/2023 16:00​
3jan/23
01/01/2023 15:00​
4dez/22
02/12/2022 14:00​


Can someone help me? Is there any formula in excel to do this? Thanks
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Note: Based on your sample above, I think you should be able to get what you want with a simple Filter. Just filter out the rows where column B is blank.
 
Upvote 0
I'm using excel 2007. I would like to use a formula. Thanks
 
Upvote 0
Excel 365 has a great new "FILTER" function which makes this very easy to do.
Unfortunately, it is not as easy to do on older versions. It looks like you would need to use some sort of INDEX-AGGREGATE formula.
I am not knowledgeable with that formula, as I used Microsoft Access for all my filter needs prior to the Filter function (Access was built for stuff like this!)
But I did find a video which shows you how to do it:

There are many other videos/articles/tutorials on the subject.
 
Upvote 1
I'm using excel 2007
Also, please update your Profile, as instructed in the link provided in my first post, so it easy for all to see which version of Excel you are on.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,245
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top