#formula

i have a column in a table which is using a formula to calculate a percentage , i used this formula =COUNTIF(Table1[%],"<5%") but it returned the wrong number and i have no idea why

Dear All, Please help me to correct below IF condition, I want to breaks value of "No. of lives" according to given financial year from start date of policy. I have tried to solve problem with IF condition in F4 & G4 but unfortunately my formula works only for tenure 1. My Formula : for...

I started using VBA in excel I have a spreadsheet named "MasterReport" 1. this macro will create a new spreadsheet and name it with the value in MasterReport's cell "B2" (OldDatax) 2. the existing data will be copied and transferred to the "oldDatax" sheet everytime I run the macro 3. Fresh...

Dear all, Happy to join mrexcel ! I have an brain teaser with VBA. I want to create a macro that will color: - Hard coded cells in blue police. - Formula (ex: vlookup): In black police. - Linked cells (ex: =Sheet1!$B$5): In green police. Do you have a code that could work out ...

Between two Slashs "/" Or Two and more Slashs how to work formula in this condition

I'm not really even sure how to query this so I'll provide an example and then explain further: JT005 JT005 BB005 BB005 BD010 These values are pulled in from an agent database. The structure is always a string of 5 characters- the first 2 are alphabetic and correspond to the person's...

Hi Everyone I have a file with a date/Time format that I am having some issues with. I have tried correcting this using both of the formulas that work with dates. The only way that I have found to work with it is to run text to columns and then build the date up from each of the columns that...

:confused:I have a worksheet that searches for staff name, thenpopulates their information from a reference sheet. Then there are trainingclasses listed, and the second formula searches for their name in a trainingrecords table, and if their name and that class title is found, it populates...

Hi, I have some formula's that I am trying to replace using Power Query.... not sure what the best way to explain this is but I will explain the scenario in excel first. I need to look at column 1 and return the value specified in the lookup table, but if the number doesn't exist in column 1...

Hi Folks Currently i have a timestamps column in this format.... 2/10/2018 10:43 AM... Now i want to add random seconds in this existing timestamp column like 2/10/2018 10:43:04 AM, 2/10/2018 10:43:09 AM, 2/10/2018 10:43:18 AM, 2/10/2018 10:43:28 AM and so on like this.... Please suggest me...

I have an Excel 2016 PowerPivot data model where I'm trying to find a member value based on whether 4 other member values exist. A sort if "if" statement. If Values A, B, C & D exist, bring me back value E. Value E can be 1 of three things based on values A-D being found. I've researched...

<tbody> Name Section Class Score Medal Bob #C 9 98 Daniel #C 9 98 Jon #C 9 97 Tom #C 9 96 Alice #C 9 95 Elisabeth #C 9 95 Robert #C 9 91 Mertin #C 9 89 etc. </tbody> I'm trying to use a formula that allows me to choose the medal (gold, silver, bronze) gold -...

I need a formula that will count the numbers within a range of formulas..ex: in cell A1 838800 cell A2 838809..im using 1+ (A2-A1) which works but if I have nothing in A1 and A2 I don't want it to show a 1..i want 0 as this is messing up other totals

Hi all experts out there, May I know why my below formula work for Excel 2007 but not Excel 2002? =IFERROR(INDEX(PartNum!A1:C45000,MATCH(1,(PartNum!B:B=SR_From!H10)*(PartNum!C:C=SR_From!H11),0),1),"") As for Excel 2007, there is nothing display when nothing match. Whereas when open the Excel...

I struggle with CountIf functions. I know this should be pretty straight forward, but I can't wrap my mind around it. Below is how the spreadsheet is set up. Don't worry about the conditional formatting of the cells or colors of the dates below. Just for visual. But I want each cell to auto...

Hey! So, I have long list of names like Jack CK, Paul IK, John PK and so one in one column and lets say that column is B. There is also other information like birthday (C) and city (D) etc... So I have one shell where I put name G and I want formula that replays every other information linked...

Hey, I have tried to do following thing... I have list of codes (numbers) on another sheet and one form on another where is just one cell in one of the 30 rows where that code have to go. Problem is that when I drag down that form and try to make many of them with each filled with different...

How would I write a kind of tiered formula? If a number is over 900000, i need it multiplied by .0015 If it is between 700000-900000, i need it multiplied by .00125 If it is under 700000, then it is 0 Please help! Thank you!