Can you please let me know how to extract the detail from first sheet to second sheet
The below is the date in first sheet
Date Process Name Type Comments
17-08-13 abc Jane Error xxx
18-08-13 xyz Hanna Feedback yyy
19-08-13 aaa Alfy Error fgfgdfgfdg
18-08-13 bbb Debra Feedback ererer
19-08-13 abc Danny Error hjhjhj
Answer expected in next sheet as below
2013 Jane Hanna Alfy Debra Danny
January
February
March
April
May
June
July
August 1 1 1 1 1
September
October
November
December
Last edited by Jemima Sugantharani; 08-17-2013 at 05:16 AM. Reason: Wanted to attach an excel file but couldnt
would be great if u provide sample workbook with desire output
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
i dont know how to attach the excel
see my signature part there u will find steps
I think i have attached the excel
u just want the count name for a particular month right
Hi, Jemima Sugantharani,
maybe add a pivot table, get the dates into the rows, group them by month and year, get the names of the persons to the columns and and values into the data range.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
try this attached file
Yes you are right. If i enter date month and year in the first sheet i would need the data for that month as consolidated in the second sheet
If the person gets two feedback and one year i need the count as consolidated for that month
Updated file attached for your reference
If i change the date in the first sheet i get an error message in the second page
Now try this....
i am not getting any error while changing the dates
See the attached file with error in second page when i changed a date in first page highlighted in red
I would not disagree that a pivot table is the way to go, but to do as you ask, look at SUMPRODUCT().
See this workbook.
Last edited by Marcol; 08-17-2013 at 06:52 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
no its not showing any error i have checked
but did you see my excel with error message when i change the date
everything showing correctly u have 19/09/2013 right for this date name is Alfy and type is external er right for this criteria in sheet2 its showing count 1 for alfy external er column september months
Please see the error message screenshot when i changed the dates in first page
put the cursor on formulated cell and take a screen shot and attached
i think as per my understanding COUNTIFS function will not work in Excel 2003 version, i will give u another formula
When i open the sheet from you its perfectly correct (both first and second page). After that if i change the date in first page it works perfectly fine in first page only the second page faces a name error. Screenshot attached
before formual its showing something like this =_xlfn. what is this
i dont know
Have you looked at post #14? It works for all versions of Excel.
This is it on a second sheet
Last edited by Marcol; 08-17-2013 at 06:56 AM.
try this attached
Hi,
regarding _xlfn: http://office.microsoft.com/en-us/ex...010204569.aspx. Not supported function CountIfs in 2003.
@Marcol:
can´t find the link to the workbook in #14 (it´s Saturday, maybe just the normal issue with the Forum on Saturdays and Sundays). Edit: okay, didn´t show up in the preview at #24.
Ciao,
Holger
Last edited by HaHoBe; 08-17-2013 at 06:54 AM.
Eg:
Fruits vegetables
apple tomotoe
orange potatoe
mangao brinjal
pine carrot
cherry beans
now i have a drop down for Fruits & vegetables. Underneath i have another list box which when fruits are selected the types of fruits should be in the list . please help urgent
@ Holger, it got corrupted while loading, I had to repost it. It seems okay now.
No i get #num! err message
This has nothing to do with this thread!!!Originally Posted by raji123
@ raji123
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Hi
Please update can you try the sum product formula in #9 (updated sheet). Do we have any other formula other than sum product as it is a very lengthy formula to edit
did u tried my attached file try this and its easy to edit as well
Screenshot of error message attached while editing
change the date and reference the pivot , have look and let me know is it fine or not
Re: Count a data from the list
Hi Naveed,
Thank you very much. I made some small changes in the formula of yours and its working fine.
Your sheet layout and request makes the formula longer using SUMPRODUCT() merged cells are not a good idea.
You could use this, and suppress the zeros
Formula:
Please Login or Register to view this content.
Or use the same formula in an IF() statement as in the example workbook.
Why do you want to edit the formula?
Just enter it in B4 then drag it across then down.
Hi jemima,
Glad to hear.
if u satisfied with solution, then please don't forget mark this thread as solved and also click on Add Reputation.
Thanks- Naveed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks