excel formula

How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ??? EXAMPLE : Like Certificate Number & Date Matching With Paragraph Text , I try Match Condition Text With Paragraphy Both Text Are Match : Condition Show is "TRUE" Both Text Are Not...

Hello every one .. If i have a data set like this one in the attached picture , Is there any way to find the positions as a result in column "P" by finding the the smallest values in column "O". Notes that there are a duplicated smallest values in different positions in the data set.

# HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST i try target this Drop-down list but not working my Index+match formula .... pleased help this ......& Do Correction my formula.....

All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......

I have this if statement that calculates a due date for me, it works fine but I now have a new situation that created the need to modify to exclude the calculation if column E contains the work "Broker". =IF(K21<>"","N/A",IFERROR(WORKDAY.INTL(N21,-3,11,Holidays!$D$5:$D$26),"")) Here is what I...

I have a spreadsheet in which I dump some data from SAP, which ends up looking something like this I then insert a formula in J2 which is supposed to find the latest date / month there is a registration for. However, it doesn't seem to be able to interpret values in column D as dates. What...

My laboratory is capable of running 20+ different analyses, and we get contracts from about the same 15 companies to do a combination of these analyses. I created an Excel spread sheet to keep track of the work as it comes in, where columns are the 20 different analyses we can run, and rows are...

Condition-1 Match List-1 & List -2 Number & Show result in list-2 "item" Cells........

I have a column that uses VLOOKUP to bring in values from another sheet. I would like to save the precious value of any cell in this column to the corresponding cell in the next column whenever the cell value has changed. Example: Current values: Cell A1=1, A2=2 If VLOOKUP brings a different...

Hi, We manage admissions data back-end. Our applicants go through interviews with 2 interviewers and this data sample is automatically populated using MS forms and Power Automate. However, this is what we need for the compilation of data in our mastersheet. For every 2nd interviewer, we...

Hi, Please help with formula or a method to calculate per employee job level salary cost for different departments when we only have is total salary cost employee for entire dept. We are also given average salary for each level of employee. Below are the details Average salary per Job level...

# How to sum with unique Invoice Number wise ????? - Pleased Solve this query for formula ......very usefully trick for sale bill fill. like single invoice & two or more products in this sheet... problem is how to sum product based on unique Invoice No. - Pleased Help !!!

Show Result : 3 (Pleased Show this Query........................................)

like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????

I have excel sheet, which has value stored as price in "D" column now, I want to highlight particular cell in column "D" which satisfies below 2 conditions XFB9<=0.02 which cell has highest value among cells that has fulfilled above condition (column "D") issue I find here in writing formula...

Hello guys, Need your help in getting the Excel Formula based on condition, 1. If Column A = Current Month and Column B > Current Month then Result in Column C is >MO 2. If Column A = Current Month and Column B = Current Month then Result in Column C is MO 3. Rest should be mentioned as Nill...

Hi, I have list of employees with their goals, each employee has at least 3 goals and each goal has a different update goal date. My question is how to figure out the most recent update date of each employee? What is the right formula? Below is a sample of employees list: EE ID Last...

I want to create a chart with two columns: one column will be my budget, the other column I want stacked to show what I have spent so far and what I expect to spend. I tried faking it by creating two charts (one for budget, the other for the stacked), but this can cause problems when the sum of...

Hello all, I'm looking for a formula for cell J5 that can calculate what the cost would be for the entire month of May based on the information below. I am hoping to make a formula that won't require to be updated even if there are new trips with new months, # of people, (The location will...