logic

I am exporting a report that is giving me time in a sales funnel for each lead. Unfortunately, it spits out this data in one of three forms: X Minutes, X Hours, or X Days. I want to write a logic statement that says, If the cell end in "Days", multiply the number the cell starts with by 24. If...

Hi, I'm new to this forum so hope this hasn't been asked before. I have a large data set where I have rows that contain the same data on 2 columns. Let's call them ID number and Car Model. I only want to combine the rows IF ID + Car Make = ID + Car Make of another row (e.g. duplicate) AND the...

Hello, I need help setting a formula for lead time in transit. The receipt date always must fall on a Monday. So when someone ships on a monday, tuesday, wednesday then the dock date should equal to the following monday and if the ship date is thursday or friday then the dock date must fall on...

I have been given this data and asked to calculate the Bid Rate and Win rate. I am not sure if it would be a ratio or a percentage, I got a little clarification for bid rate that it should be a relation of the actual no. of bids compared to the no. of qualified events to bid on. So it would be...

hi, I'm new to vba and im trying to do a OR,NOT, AND operations on a selected range per each row, the way I want to do it get user input to select the columns first through input box then use those columns to do the operations, all the coloumns are consisting of only 0`s and 1's. if the user...

Hello! I am new to the forum and to excel. We have a huge excel database that we would like to transfer to an SQL Server. The database consists of PowerPivot tables and some regular ones that apparently come from tab delimited text files. The problem is that to mimic the PowerPivot...

Currently I have my data show stats for the previous day. For example on Tuesday I show Monday's data, on Wednesday I show Tuesday's data and so forth. I need help making a formula where on Monday's I can show Friday's data. I don't need to show the weekend data. I've played around with IF...

Hi, I have a problem where I need to add an extra function to a formula. I currently have the following table on a worksheet:- <tbody> A B C D E F 18 Log Cabin Quantity Size Notes Twin Skin Insulate Floor 19 Cowbeech 1 3x3 1 1 20 Brightling 21...

I require some help with a logic formula to populate the next date for an assessment schedule. I have 3 columns. Column A contains a frequency: "annual" biannual" or "N/A" Column B contains a 4 digit year: 2014, 2015, 2016 etc Column C needs to contain a formula to populate what the "next"...

I'm trying to incorporate a new feature into an already existing spreadsheet I maintain, but I'm having trouble finding the right functions and/or logic. Basically, I'm trying to give the user a column (in this case, B, in the table below), which will allow the value in Column C to be modified...

I have a chart with two columns, A and B. In column A, I will input one of three values; "A", "C" or "D". In column B, there will be numerical values based on other calculations, either negative values or positive values. I.e. each row will contain one value in column A; "A", "C" or "D" and one...

Hi there !! :-) Could someone please help me with this. Say i have two cell A1 and A4 If a specific condtion is met in A1 { Say if value of a1 =3 } then A4 should freeze and should not exept any value. Help will be much appreciated. Thank you

I have two columns, containing a person's data on repeated measurements and other one with the presence or absence of a characteristic. Data reads like this; <tbody> PatientID Characteristic Yes/No 1 N 1 Y 2 Y 2 Y 2 N 3 N 4 N 5 Y 5 Y 6 N 6 N </tbody> I want the number...

So here's the question I haven't been able to figure out. I'm trying to build a master pin chart for locksmith purposes. One of the steps is to subtract the smallest to the next largest number. For example, if the cuts for the three keys are 545, 768, and 332. Lined up 545 768 332 The...

Hi there, I am working with a spreadsheet that deals with construction costs that is giving me trouble. In this spreadsheet, I am given the total cost of construction as well as the start and end date for the project. My goal is to approximate (on a monthly basis) what the total spend per...

I have a spreadsheet we use to display our Fantasy Football auction on a big screen in a conference room. Ten guys take turns 'nominating' a player, who can then be 'bought' by anyone. My sheet lists every nomination, 1-160, going through a logical sequence (Team A, Team B, Team C, Team D...

I have 1000's of rows of data. I need three actions to run based on data in two columns (out of about 8 columns). -Find all groups of duplicates in column A -With in each group of duplicates determine if value in column B is >= 20140501 -If true, then delete entire group of rows (including...

Hello Everybody, I have a business requirement to come up with a list of conflicting duties for any person who has duties assigned. I am not able to get the logic to do this on Excel and would need some help. Tables I have (Inputs): 1) Name and Duty <tbody> <tbody> Name </tbody>...

I have a workbook that is titled "Results". It has 2 columns that I need help with, a 'status' column (B) and a 'finalized date' column (C) Column B is the 'status' column: Formula: ('[May Database]Summary'!$B$1) The May Database B1 column is a dropdown with options "In Progress" and...

I've got a spreadsheet I need to average data in. I'm using links to pull my data from other sheets to this one. If there is no data, my other sheets display "NoData" in the cells. I did this because some of my data may contain zeros. I need to average the values of the cells that contain actual...