Report value of cell based on search
Solved/Closed
Hello, in Excel I can use a Sumifs to search a column for a value and return the total of cells that match that value (how many "calls" did "Sally take at "8:00?)
Is there a way to search for a value and return a 'value' of another cell?
If 'cell' = Sally, then report value in 'cell'
For example how many hours did Sally work? The spreadsheet is doing a counta to total hours, then gives a total at the bottom. I'd like another view that shows 'name' and 'total hours' - the sumif would do if - if it didn't do a sum! it would be a valueif I guess (smile)
Is there a way to search for a value and return a 'value' of another cell?
If 'cell' = Sally, then report value in 'cell'
For example how many hours did Sally work? The spreadsheet is doing a counta to total hours, then gives a total at the bottom. I'd like another view that shows 'name' and 'total hours' - the sumif would do if - if it didn't do a sum! it would be a valueif I guess (smile)
Related:
- Report value of cell based on search
- Crystal report viewer download - Download - Data management
- Google.us search - Guide
- Yahoo search history - Guide
- How to search nearby friends on facebook - Guide
- Safe search settings - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 17, 2010 at 11:33 PM
Aug 17, 2010 at 11:33 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too