impossible

Alright Guru's I have a fun one for you guys that I cannot figure out. So I have an input table that has 52595 rows of data. One of the columns has the information below. GPN-17-308 OC16-003-GPH OC16-134-GPH-G IPO-18-249 16-105-3ST-B These are basically Job numbers. The important parts are...

Hello folks, Bit of a strange one - I am working on correcting data inconsistencies in model numbers sent by an incorigible supplier. The goal is finding the following string within a cell and appending the letter X at the end: (letter)(4 consecutive numbers)(letter in defined list - [E,V]) ->...

This seems like it would be easy, but for the life of me I can't figure it out. I have three column ranges on a worksheet and i was trying to copy them to a different worksheet. BC-BX CA-CV DR-EM EO-FJ I think the column lengths are all equal. Is this even possible using Excel? Or do I need...

We normally report sales as Total Goal & Total Digital Goal against Total Actual Sales & Total Actual Digital sales, weight both at 50% add them together then take that percentage and give a base percentage with an accelerator for any amount over. For example: <tbody> Goal Actual % to Goal...

I have an interesting average question for you. I have a number that we will call x I have 15 random numbers. I want to work out what combination of 12 or more of these numbers will result in an average that is the closest number to x. I would then like excel to highlight which 12 or more...

I would like to know if it is possible to complete a "Find and Replace" but replace with a formula as opposed to a value?

I have the following issue where i have to analyze actual bookings, and ensure they follow the allowed combination criteria. How can i make an excel vlookup/macro which compares the actual bookings to the allowed combinations, and if they dont meet the allowed criteria, returns an N/A? Actual...

I have the following issue where i have to analyze actual bookings, and ensure they follow the allowed combination criteria. How can i make an excel vlookup/macro which compares the actual bookings to the allowed combinations, and if they dont meet the allowed criteria, returns an N/A? Actual...