Data Filtering

[shubhamdeokule]

Hello, I hope you doing good

I have an issue see the attached image. It has 3 rows Username, Reporting, and date. now I want to see what danu66 posted on 8 August 2023. This is data where an employee reports what he will be doing every day so the data will be updated daily, which means the name of the employee (the name is unique) will come every day. I want to get the data of a person on a particular data how can I do that? Please help

 

[Ezguy4u]

shnub Now your table has filters in it. Do you not want to use these filters? I filtered on the name and got the results below. Am I missing something? Let's get the ball rolling and start the discussion. And If you could download that XL2BB app it would be nice. Then you could show us input and output.

Screenshot 2023-08-15 023923.xlsx
	A	B	C	D
1	Username	Reporting	Date	Time
2	danu66	1.Revisions	8/6/2023	10:41:01 PM
19	danu66	Day 81. Revisions2. Gi	8/8/2023	12:27:35 PM
Data

 

[shubhamdeokule]

shnub Now your table has filters in it. Do you not want to use these filters? I filtered on the name and got the results below. Am I missing something? Let's get the ball rolling and start the discussion. And If you could download that XL2BB app it would be nice. Then you could show us input and output.

Screenshot 2023-08-15 023923.xlsx
	A	B	C	D
1	Username	Reporting	Date	Time
2	danu66	1.Revisions	8/6/2023	10:41:01 PM
19	danu66	Day 81. Revisions2. Gi	8/8/2023	12:27:35 PM
Data

I will be creating another sheet where this data will come same like this, and this above will be the source of a data I want to get filter it. I used xlookup but the issue is I don't know how to put two condition like I want to search danu66 only of a particular date

 

[rondeondo]

One way to use XLOOKUP with two criteria is to make an addional column with the two criteria concatenated together, ie:
In column E

=A2&C2

Then in the sheet you're searching from you do this with the search data and refer to column E in your source data

 

[Ezguy4u]

Ok Shnub if I may be so forward as to guess at what you want. I have 2 worksheets. Original and Data. So you want to be able to put 2 conditions for input and Data would be the output. Is this close to what you are asking for? If it is then we can start from here. If it's not then we have to try something else.

23-08-14 filter.xlsx
	A	B	C	D
1	Username	Reporting	Date	Time
2	danu66	Day 81. Revisions2. Gi	8/8/2023	12:27:35 PM
Data

23-08-14 filter.xlsx
	A	B	C	D
1	Username	Reporting	Date	Time
2	danu66	1.Revisions	8/6/2023	10:41:01 PM
3	.iris11	Day 7Complete 6 Give	8/6/2023	10:42:51 PM
4	Aryaman	Day 7( gonna be the bil.	8/7/2023	12:00:01 PM
5	anirudhmawa	Day 6Financial manage	8/7/2023	1:35:24 AM
6	ayesha0068	Day7 classes as pp + r	8/7/2023	2:11:02 AM
7	vishwajeet14	Day 7ROE lectureFinal	8/7/2023	2:51:33 AM
8	yoginderk	Day 7Audit revise ch 4 .	8/7/2023	3:22:39 AM
9	kirankashyap	Day 71. Inventory reval	8/7/2023	3:24:06 AM
10	nishant gupta	Da 7MaterialTaxation ri	8/7/2023	3:56:10 AM
11	sanjyoti13	Day 7Gst practice Cos	8/7/2023	5:40:11 AM
12	nitesh6295	Day7Maths lecAcc lec	8/7/2023	6:13:30 AM
13	bettercallyash	Day 7Backlog completi	8/7/2023	8:26:38 AM
14	shikharag	Day 5Incomplete recoil	8/7/2023	1:07:36 PM
15	navya4805	Day 7Accounts chapter	8/7/2023	3:18:49 PM
16	kush3255	Da 7Fm Sm	8/7/2023	3:50:00 PM
17	rekha90	Da 7Some Lectures	8/7/2023	4:14:00 PM
18	siimzie	Day 8 Portions of mark	8/7/2023	8:05:18 PM
19	danu66	Day 81. Revisions2. Gi	8/8/2023	12:27:35 PM
20	sanjyoti13	Day 8Accounts revision	8/8/2023	1:10:42 AM
21	yoginderk	Da 8 Com•lete •endin	8/8/2023	2:15:49 AM
22	Aryaman	Day 8 1) 5 lectures( 8	8/8/2023	3:12:36 AM
23	kirankashyap	Day 81. Maths tvm revil	8/8/2023	3:21:32 AM
24	vishwajeet14	Day 81. Maths lecture2	8/8/2023	3:22:33 AM
25	bettercallyash	Day 8Fm 3 lectures Ta)1	8/8/2023	4:08:07 AM
26	.irisll	Day 8Complete 6 Giver	8/8/2023	5:21:55 AM
Original