houston

I'd like to sum all of the dish sales based on the Location number and Product IDs. Can I do this without creating a helper column? <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Location Product ID Product Desc Sales 2 555652 Houston 10047108 Dish 12" 4 3 555652...

I couldn't come up with a clear title. Here's the question with a proper example. Two Tables of Data: TABLE A <tbody> Name GP M P A R James 80 3040 2320 880 480 Steph 72 2448 1800 576 288 Kevin 73 2555 1971 511 511 Chris 78 2730 1404 780 234 Patrick 80 3200 1760 160 960 </tbody>...

I have a column with different location names, and another with their temperatures on different consecutive locations. Each city has a random amount of points/locations (around 40) For example: <code>Houston 10 Houston 11 Houston 14 coruna 20 coruna 21 coruna 25 coruna 28 vigo 30...

This is just a concept at this point, but I wonder if its even possible with Excel... Say that A1:A10 are filled with search terms - apple, lug nuts, house cleaners, car mechanics, lawn care, etc - the terms don't matter at this point. Additionally, in B1 is a location (a city or state name)...

I cannot figure out how to extract this from all the other examples I find here. (Great site, thanks everyone!) Text A1: Bob Smith ~ 123 Main Street ~ Houston ~ Texas ~ 77001 I need: B1: Bob Smith C1: 123 Main Street D1: Houston E1: Texas F1: 77001 Thank you!