Question description:
This user has given permission to use the problem statement for this
blog.
Hi ,
I am trying to compare 2 if statements from 2 worksheets, if that matches then i need the count
Solved by B. Y. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
16/10/2018 - 11:19
can you help me here
Excelchat Expert
16/10/2018 - 11:19
Welcome, Thanks for choosing Got It Pro-Excel. I can help you with that problem.
User
16/10/2018 - 11:19
ok
Excelchat Expert
16/10/2018 - 11:19
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert
16/10/2018 - 11:19
Do you have sample data which we can use to illustrate how to solve this problem?
User
16/10/2018 - 11:19
sure
User
16/10/2018 - 11:20
[Uploaded an Excel file]
Excelchat Expert
16/10/2018 - 11:20
Just a moment as I follow closely your problem description and the data provided...please
User
16/10/2018 - 11:21
I want to comapre within worksheet 1 and 3
User
16/10/2018 - 11:22
i want to check if B1 from sheet 3 equals wth sheet 1 column C, then i need to count the no of occurences of the name from sheet 3 with respect to sheet 1 data
Excelchat Expert
16/10/2018 - 11:23
Okay. Where do you want to put the result?
User
16/10/2018 - 11:23
in sheet 3
User
16/10/2018 - 11:24
let us take an example on "Rajju"
Excelchat Expert
16/10/2018 - 11:24
The file you sent has only one sheet.
User
16/10/2018 - 11:24
it must be having 3 worksheets
Excelchat Expert
16/10/2018 - 11:25
Kindly confirm that you uploaded the correct file.
User
16/10/2018 - 11:25
I have uploaded the data in the blank file here
Excelchat Expert
16/10/2018 - 11:26
Okay. Let me have a look at it.
User
16/10/2018 - 11:27
i want a formula where B1 (sheet 2) matches with column B and if it matches, then i need the count of occurences of the name given in Column A(Sheet 2)
User
16/10/2018 - 11:27
Column B(Sheet 1)
Excelchat Expert
16/10/2018 - 11:27
Okay.
Excelchat Expert
16/10/2018 - 11:28
Based on what you’ve shared, you need a formula to count the numbers of times the name in column A appears within a particular date.
Excelchat Expert
16/10/2018 - 11:30
I am creating a formula that will solve this problem. Will get back to you shortly.
Excelchat Expert
16/10/2018 - 11:32
We are counting against the auditor column, right?
User
16/10/2018 - 11:34
yes
Excelchat Expert
16/10/2018 - 11:34
Very good.
Excelchat Expert
16/10/2018 - 11:34
Thank you for your patience.
User
16/10/2018 - 11:34
I am creating a formula that will solve this problem. Will get back to you shortly-- Thank you
Excelchat Expert
16/10/2018 - 11:34
The formula is:
Excelchat Expert
16/10/2018 - 11:34
=COUNTIFS(Sheet1!$B$2:$B$432,Sheet2!B$1,Sheet1!$D$2:$D$432,Sheet2!$A2)
Excelchat Expert
16/10/2018 - 11:35
I have put it in the online sheet.
Excelchat Expert
16/10/2018 - 11:35
Is that what you expected?
User
16/10/2018 - 11:36
Yes, perfect
User
16/10/2018 - 11:36
Thank you so so much
Excelchat Expert
16/10/2018 - 11:36
Yaaay!!!
Excelchat Expert
16/10/2018 - 11:37
I am happy for you.
User
16/10/2018 - 11:37
but if i change the date at the top
Excelchat Expert
16/10/2018 - 11:37
Do you have any other questions or clarification you may need about this problem and the solution?
User
16/10/2018 - 11:37
can we get the same data
User
16/10/2018 - 11:37
as in if i put 6-Sep-18 in place of 5-Sep-18
Excelchat Expert
16/10/2018 - 11:37
If you change the date, it will return results for that particular date.
User
16/10/2018 - 11:37
oh perfect
User
16/10/2018 - 11:37
Thank you :)
Excelchat Expert
16/10/2018 - 11:37
It was my pleasure helping you solve this problem. Any time you have a problem with Excel do not hesitate to come back for help.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.