populated

HI I am working on a project status report if a date field is populated then calulate a % in a differnet cell. I have 4 steps in the process each 25% to complete if excel date field populated then add 20% to complted project <tbody> a b c d e f 1 % Completed 25% 25% 25% 25% % Complete 2...

I’m looking for a very specific formula. My data would be laid out as such. A5 would contain a date that a document was forwarded B5 is the slot for the documents due date I want multiple things to happen I want B5 to auto populate a due date using the workday function that part is simple...

The formula below returns "#NAME?" and I don't know why. I suspect the reason may be because there are columns used in the equation that are formula cells. But if this is the reason, how do I get around it Basically the formula is trying to achieve a sum of column O if two conditions are met...

Hello everybody. I need to define a range from A1 (top left of the range) to the last populated cell on the right, and to the last populate row downward. https://imgur.com/a/keBiXeZ In this case, the range has to be A1:D21. Consider other cells in other areas could be populated. Thank you.

Hi Guys, I am working on an excel file where I have 300k rows and 160 columns, In few places, I have to compare two nearby fields and populate the status on the third field(Status field) based on below mentioned rules. I would like a single formula(Multiple ifs?) to accomplish the same. In the...

Hi all I'm really struggling here - any help would be great. I have a spreadsheet where I am trying to record (in cell F4) that actions are either open or closed off. Where actions are open it is automatically highlighted red. I have the following formula. =IF(E4<>"","Closed","Open") all good...

My statement is not returning any value unless I manually input values for the statement to evaluate. Font is set to general. I intentionally have my condition values to be equal to a cell. Below is my formulas that should work. I’m stuck and frustrated. I think it’s self explanatory, but...

I have up to 1,000 entries (column A) on my Output worksheet. Some of them (100 or less) are in bad format or simply wrong. In a separate table on my Lookup worksheet, column A is populated with 'bad' entries that match the bad entries on the Output worksheet. Column B is populated with 'good'...

Hi all, Just wondering if someone can help me with something. I have the following data: <tbody> Name f a t c t d a e f </tbody> What I want is for a list to be populated elsewhere in the worksheet which gives me only unique values. I have used the following formula...

I have a simple log file with a couple of columns to log events. One row for each event. Every cell in a row is manually entered and there are no macro's or formula's yet. To prevent mistakes I now want to make a modification in column A... the date column. As soon as one of the other cells in...

Hi all, I am trying to put together a report for school and need some help. In the attached spreadsheet, I have a summary tab and three tabs for Americas and Europe and JAPAC. For the summary tab, I need to pull in information from the three tabs (JAPAC, EMEA and Americas). For Columns C...

How Do I get the formula to go down to the last Row? lastrow = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row lastcol = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column + 1 'after last populated col lastcol2 =...

Hello everyone, I am looking for a formulate to incorporate the if function to another function that would avoid leaving gaps (empty cells) in between. So I have data from lets say A1:A50 I want non zero values to be populated in column B without gaps in between. Sorry if this is too easy...

How do I Copy the data from 3 separate combo boxes to 3 cells in Excel? I have 3 combo boxes on a user form, comboBoxFrame, comboBoxPanel, comboBoxEdging. comboBoxFrame is populated with a list of solid timber, comboBoxPanel is populated with sheet material, comboBoxEdging is populated with...

How do I Copy the data from 3 separate combo boxes to 3 cells in Excel? I have 3 combo boxes on a user form, comboBoxFrame, comboBoxPanel, comboBoxEdging. comboBoxFrame is populated with a list of solid timber, comboBoxPanel is populated with sheet material, comboBoxEdging is populated...

Hi, I have 2 columns, Column A with numbers in all 20 rows (forecast) and Column B with numbers populated as time progresses (actual). In the total of Column A, I only want to SUM the number of rows that are populated in Column B, so I can get a proper Month To Date comparison. So for...

Good morning, I'm stuck on this problem. Two drop-down lists. One is in A1 The other is in B1 User selects 'customerA' in cell A1, B1 should then be populated with data from worksheet 'customerA'!$A$2:$A If user selects 'customerB' in cell A1, B1 should then be populated with data from...

Hi All, I'm stuck on some CF and hope someone can help please :) I want to CF to highlight non-blank cells if B4 is not N/A. I've tried using formula below but not sure why it isn't working. =IF(AND($D4='ConditionRatings'!$A$1:$A$4),AND(COUNTBLANK($D1:$D5)>0)) E.g. If B4 is "1" then B1, B2...

Hello Everyone! I would appreciate assistance on a Macro I am working on. I added Column D, into which data will be concatenated from Columns A, B, and C. I would like Column D to AutoFill with the Concatenate Formula in Cell D2 until the last cell of Column D that corresponds with the last...

I'm looking for a formula that will provide the following result: If b9= selection "a","b",or "c" and b11 is populated then result would be "ok to save" If b9= selection "D", then look for B20 and if it is populated the result would be "ok to save" otherwise result would be "not ready to...