06-06-2013, 07:22 AM | #1 |
Stay Classy
76
Rep 1,021
Posts |
Any Excel Pros?
I'm trying to find an excel function that will take data from one sheet and place it into another when there are values in those cells.
Basically, there is a general parts pricing estimating sheet that is huge and you have to sweep through the whole thing to find which cells have values. Is there a function that will search the page and bring up only the cells with values? |
06-06-2013, 08:39 AM | #2 |
Major General
2458
Rep 7,341
Posts |
I'm positive that I could help but I'm having a hard time understanding what you're trying to do.
__________________
The views and opinions expressed in this post are those of the author and do not necessarily reflect the official policy or position of Bimmerpost.
2018 Jeep Grand Cherokee High Altitude Hemi | 2010 S4 Sold | 2010 BMW 135i Retired | 2006 Lotus Exige Sold |
Appreciate
0
|
06-06-2013, 09:55 AM | #3 |
Get to the chopppper!
11
Rep 121
Posts |
You can use the function =len()
=len() counts the # of characters in a cell...if there are no values, it will be return 0. You can filter to not include 0. Let me know if this helps. |
Appreciate
0
|
06-06-2013, 10:22 AM | #5 |
///M Fan
368
Rep 2,159
Posts
Drives: '09 E92 M3 IB/'17 f85 X5M LBB
Join Date: Sep 2008
Location: Canton, GA.
|
You can also use = CONCATENATE ()
Edit: the more I think about it, vlookup would be better. The above is more to put together two different values into one cell.
__________________
'09 E92 ///M3 Interlagos Blue,6MT,Silver Novillo Leather,CF Trim,Premium Package,Technology Package,Cold Weather Package,Premium Sound,19"Wheels,Moonroof-Toy/'17 X5M, Long Beach Blue, Executive Package,Technology Package, Lighting Package, Driver Assist, Full Mughello Red Interior, 21" wheels-Toy/'14 535i with M Sport and 19" wheels-Daily
Last edited by elm3; 06-06-2013 at 10:28 AM.. |
Appreciate
0
|
06-06-2013, 10:44 AM | #6 | |
Stay Classy
76
Rep 1,021
Posts |
Quote:
What I need to do it is create a sheet that will list the quantity of the products used for a specific job. If say, products A-Z are available for a job but only products A,B,D,G,T,Z were used. VLOOKUP() would search through products A-Z and show all the quantities and list everything that was not used as 0 and list the quantities for A,B,D,G,T,Z. This sound correct? |
|
Appreciate
0
|
06-06-2013, 11:00 AM | #7 |
Stay Classy
76
Rep 1,021
Posts |
ok here is a generic screen shot of what I'm working on. Sheet 1 is the sheet from the job and Sheet 2 is the one I'm making. I used VLOOKUP() to auto fill Sheet 2's quantities for the products reflected from Sheet 1.
|
Appreciate
0
|
06-06-2013, 11:42 AM | #8 |
Major General
4459
Rep 9,160
Posts |
Use FALSE in the vlookup to make sure you only get exact matches. You can use an ISERROR to fill 0 or "" if the vlookup comes back with an error or blanks.
|
Appreciate
0
|
Post Reply |
Bookmarks |
|
|