EXCEL FORMULA - Count plus one. Incremental count?
Column A I have CAR TYPE. Column B I have STATUS. Column C I have QUANTITY.
Column A can range from many car names that can show up multiple times (Ex: Honda Civic can show up 2 times and Sonata can show up 5 times). Column B is the status of whether the car is "Broken or Active". Column C has the number/quantity of car types left for that specific car.
Column D is the lot number (location) of the car which I have a count formula that'll determine it's location. In Column D, I have an incremental count of the column A if Column B is "Active" and Column C is greater than 1.
So if Honda Civic shows up 3 times and they are all active and quantity is greater than 1, and Sonata shows up 1 time, the location that shows up in Column D can be LotA1, LotA2, LotA3 for Civic and LotB1 for Sonata in Column D.
HOWEVER, let's say the LotA2, for Honda Civic status is "BROKEN", I want LotA1 and LotA3 to still be there and the next Honda Civic that shows up that's active and quantity greater than 1, the lot number in Column D should say LotA2.
Your question is a little unclear. Are you placing the three lot designations for Honda all in the same cell in column D? Or do you just want to omit the lot designation in column D for 'BROKEN' entries?
- Where can I buy a 2009 honda s2000 formula red? I've been searching but hardly find the exact one as I'm the title eithere there red with a different year or the same year with another color but I want exactly a 2009 honda s2000 formula red please help thanks.
- Which head light is best for Hero Honda splendor plus (2009 model) (No self start)? I have splendor plus bike 2009 model. I have 35/35w halogen h4 bulb plugged for its headlight. But it is not comfortable for night riding. Then I replaced it from OSRAM H4 halogen R2 off-road 60/55w halogen. But it also not comfirtable for night riding on Highways. It is ok in empty road. Light intensity is very low. Please give me sugession which headlight can be used for better & Bright and safe night ride? Give me full information about head lights?
- Spark plugs covered with oil plus exhaust smoke? Just got the carbs cleaned and working perfectly on my 82 Honda Nighthawk 450. I started the bike and just a moment later there's a white smoke coming from the engine and exhaust. I took the spark plugs off to aid in addressing the issue and I have found that there's a black oil on them. Anybody have an idea as to what's going on here?
- If one or two ISP's ban a site and raise prices, can a new one rise up and compete? Why? Why not? What about Honda/Toyota? Or ' MCI & Sprint muscling AT&T aside? Anyone remember Nucor Steel? Each of those took advantage of very different situations, each with seemingly impossible odds. Thing is, they were all LEGALLY allowed to compete. How about here?