| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
only include cells beginning with specified character or number
I want to sum the "qty" field in a database based on the "job number". I
only want job numbers beginning with 1,2,3 or 4. Below is a list of assorted job number/alpha I might use. Job number 103811 310225 350875-6 350875-7 350875-8 350875-8 370245-1 SKU#58214 Another formula I need is to sum "shipping lbs" in a database based on the product name. I only want products beginning with "c". Below is a list of assorted products I might use. Product Curriculum Curriculum Curriculum VBS FLYER RETAIL VBS FLYER WHOLESALE VBS FLYER DENOMS JUST ADD KIDS - RETAIL PICK UP N DO SAMPLER Curriculum Curriculum PRESCHOOLER'S BIBLE |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Removing ' character from cells | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Threaded Mode
