excel formulas

Hi there, can someone help me with the formulas I need under the columns Automated Deadline Alert and Progress Tracking as shown below in my Excel table? Thanks a million! Nineta

Hi, I have invoice wise outstanding details where on-account payment is received & ageing Report is calculated based on no of days from transaction date. I want ageing Report of Outstanding amount based on transaction date but on account receipt should be adjusted against last ageing bracket...

Trying to find a sensible improvement to below formula, such that separators " | " would only be included for the cells that are in fact populated. To avoid outcomes like this: ABC EFG - KF12345|KF54321|||||||||||||||\ But instead to get automatically result like this: ABC EFG -...

Hi everyone, This is my first question for this forum. Thanks a lot in advance for your help. As I showed you in the image, I have to find the 2 numbers right of H. I have tried some formulas but I could not. Like this: ==FIND(Workings_1!C2,MID(Workings_1!C2,3,2)) How can I solve this?

Hi, I have data in column B from Cell B5 onward. I have timestamps in column A from A5 onward. The graph has two lines, one is Blue and other one is Orange. Blue line comes out through the data in column E from E30 onward. Orange line comes out through the data in column F from F30 onward...

Hi all, I do a top 20 analysis where I have a summary page that has a unique ID for each line and 20 tabs( also has unique row ID) where I pivot the 20 individuals. I have to pull the comments from the 20 supporting tabs back to the summary page. I have been doing vlookups . The only way I know...

I used the above code shared by @CalcSux78 to group product names in a column with similar words. I was wondering on how it the reordering can also be expanded to include other columns in the sheet. Right now it sorts the selected column, but data in other columns remains the same so there is a...

example In Time 8:00 AM --A Out Time 3:00 PM --B formula 24*-(A-B) Answer 7.00 how do I convert this number into hours and minutes.

I'm trying to create a spreadsheet that takes multiple, "Yes", "No", and "N/A" responses and translates them into overall percentage. There are 4 columns, all of which will have a Yes, No, or N/A option as a drop down. I want the spreadsheet to be able to read the these 4 fields and give a...

HI Everyone, I am trying to calculate readings based on readings entered previously and then readings entered after the date. I know this might be a complex formula or simple for some, but I can't seem to figure it out. <tbody> Date Readings Calculated Reading 11-1-2018 60 60 11-2-2018...

Hi guys and girls, Here's me hoping there's an easy way to produce this. Help will be enormously appreciated! In short, this is the situation: I have one Support Case which went through different Stages on different Dates: <tbody> Case Number Change ID Change Date Old Status New Status 222...

Hello guys, I am struggling with a formula, I cannot think of a way to create it in a way where it doesn't need any further manual intervention. Tried with a pivot table but I can't seem to make GETPIVOTDATA to work. Can you please help me out? I have a database with Ref number/ week number /...

HI, I have a row of data and want to delete a row if the condition is true. What is wrong with my code? Sub deltotal() Lastr = Cells(rows.Count, "A").End(xlUp).row ctes = Range(x, 1) For x = 1 To Lastr Step 1 If Application.WorksheetFunction.Left(ctes, 18) = "Total for Customer" Then...

Hi, I'm trying to figure out a way to count the number of cells in the first non-zero Consecutive cells. Been reading all the posts about consecutive cells posts, but couldn't get anything working. Could anyone help? Thanks in advance! The desired results are listed below <tbody> A B C D E...

Hi, We have a pricing strategy that we want all rounded to the nearest .95 or .45 if under 500. If over 500 goes to the even dollar. If within 4.00 of a hundred, gets rounded to 99. Examples: 498.00 goes to 499.95 149.00 goes to 148.95 150.25 goes to 150.45 Is there a way to do this, or at...

AoA, Basically i converted a list from pdf and now the first name middle name and last name are in different cells but i want to combine in one cell but as a different persons names consist of different Parts some has first middle and last where some have even on five portion plz tell me how to...

I have following data that varies by time: The table below shows the base cashflows at each time <tbody> t 1 2 3 4 5 6 7 8 9 10 11 12 Cashflows CF1 CF2 CF3 CF4 CF4 CF5 CF7 CF8 CF9 CF10 CF11 CF12 </tbody> The table below shows the scaling factor that varies by...

Hey Guys, I am new to this forum and need help with excel formula to calculate Up, Down & Stable figures. A B 4 4 3 4 7 6 What I need is, If figure in ColB>ColA = Result should be "Down" If figure in ColB<ColA = Result should be "Up" If figure in ColB=ColA = Result should be "Stable" I have...

I have two rules in a sheet I have. Once that checks if a range of cell rows (7:446) in column D equal any of the values listed in column A of a sheet titled "required_refs". If the values in those rows do match the values in the separate sheet, it'll turn that cell to a red fill background. The...

Hi everyone, I am currently creating an employee scheduler using a Reversed Gantt Chart, one where the user plots the schedule in the chart then the START and END details are automatically updated (using formulas) while plotting. I used legends such as 0 - vacant hours, 1 - working hours, 2 -...