sets

I'm not sure this is possible. Maybe VBA? Ex 1: I want to select A3 (Turn Down Ratio), B3 (Number of sets), and C3 (Full Scale). Then in column E it will divide the Full Scale into 5 sets by the Turn Down Ratio in A3. Then shown in Ex 2, if I change the Value in A3 and B3, it will then...

Hi! So lets say we have two sets of dates when something is predicted to be delivered/finished. Each set has two columns: Date of delivery and order number. Assume each order number matches between the two sets, it's just that each set has a different delivery date. If we wanted to see as a...

Hello, I have an issue and I desperately need your help. I have two tables with orders (a trasaction number is a unique value) and another table with sales invoices (several invoies can be issued to one transaction number). The tables are linked via transaction numer, however when I create a...

Hi everyone, I am finding myself in this problem I can't solve. I have 150 sets, each of which has multiple element inside i.e. Set A -1 -2 -3 -4 Set B -1 -3 -10 -20 etc. Now, I would like to create a matrix with the sets in rows and colum and for each intersecation I woudl like to count...

Need help with "Conditional Formatting", specifically while working with Icon Sets. I'm currently using MS Excel for MAC 2016. How can I use icon sets when I have the following: "when value is between 90-100%, Green Arrow "when value is between 89-80%, Amber Arrow "when values is 79% or...

I'm sure this has been answered, but I couldn't find it with multiple searches. I have two sets of data (temperature VS time) in two separate workbooks. Each data set comprises 200 points, but the time measurements (independent variable) are slightly different between the two data sets. As an...

I have two sets of data which have a common field but also a unique item which I would like to combine into one data set. EG. Branch A has: Branch B has: Item# Qty Item # Qty 1 2 1 3 2 5...

Hello, we are running 3 surveys and we would like to compare how many new participants we are getting each time. We have 3 sets of email addresses from each survey. I will really appreciate your help on that, Thanks!

Hey folks Are you able to customise or create your own icon sets in Excel 2013? Patients not assessed at baseline = 15 Patients not assessed at post intervention = 5 Need the 5 patients to have a green down arrow as in this case it is better. I've googled and searched the forum but can't...

Hi, Do we have formula which counts the difference between two time sets and the results should be in minutes, it also should consider the weekends? To give you more perspective, we run a 24X5 support center and need to count the mins taken by the associate to respond to a customers query...

I'm working on a file that needs to match up time stamps but from two different data sets. The only data that matches within those two data sets is a 10 digit number. Both sheets are sorted in ascending order so the time stamps will correspond when matched. There's nothing I can concantenate to...

Hi, I am new to this forum but have been following it behind-the-scenes for a while. I have an idea that I need help executing my only challenge is that I am not an excel wizard, at least not yet. But without going too deep into the idea itself, what would be the most efficient way to remove...

<tbody> (A) Exercise (A) Sets (A) Reps (B) Total (B) Sets (B) Reps Squat 1 5 Squat 1 5 Bench 2 5 Bench 2 10 Deadlift 3 5 Deadlift 3 15 </tbody> Hey everyone, I'm using Excel 2016, and I'm trying to have Excel auto-calculate the total number of reps based on the exercise. I've managed...

I have 2 sets of date/time data I need to compare. Scheduled date/time Worked date/time Both the scheduled and worked data can have multiple entries throughout the day. How can I compare these two data sets?

Hi - I need to count the number of times a single or multiple set of columns contain "0" before the next column, which would contain a number. Probably not doing great describing it, but in the below example, I would want the formula to bring a result of 3: <tbody> 0 0 12 12 56 35 0 0 656 654...

Hi all, Really need some help to avoid some time consuming lame manual filtering. I have 50 different data sets containing three columns each. First data set is in A - Dates, B - Name and C - value. My data sets have different dates and the quantity of them differs also. But all has the same...

Hi, Is it possible to set a range in a column so it's set from last row to specific text found (header) but doesn't include the header. Example 1 - Sets the range so only the 2 rows found (Nothing,Something) <tbody> Specific Text Nothing Something </tbody> Example 2 - Sets the...

Morning All So I have a issue im hoping / praying some one may help with as its driving me bonkers as I just cant seem to nail it. It will prob be a two second job for someone who knows how to do it lol. I have two data sets within a workbook, using pivot I have pretty much got all the...

Hello everyone, I have a list from A to Z, what I want to do is to make a probability list of two alphabets, like AA, AB, AC when A series finishe I need to make B list then C, D till Z, all sets will be made in same colum after finishing previous alphbet sets... what formula will work here...

Using Excel 2000 Hi, This is challenging task; I got results in the columns C:P (R1 Through R14) I got betting sets in the columns R:AE (B1 Through B14) I want to check my entire betting sets R:AE with whole results C:P Check the matches only if the correct are grater than 9 to 14...