#excel #formula #confused

How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???

Query : " HOW TO COMBINE " ITEMLIST " & USE IN DROPDOWN LIST (Condition : Inclued Both table "Item list" * Both Table "Item list is different * BOTH TABLE ITEM LIST SHOW ON MY DROP-DOWN LIST . HOW IT POSSIBLE THIS ????? KINDLY SUGGEST RIGHT WAY TO SOLVE THIS QUERY. Note: I was make...

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? EXAMPLE: i Try this Reference "AB156480" =+A2 But I need Output : " AB156-480" How it Possible After reference ????

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...

I was try , 3 table marge but i was tried ...... i was remove this table , & make New table but this last Name Assign Problem ...... How make Running File Marge 3 table , Without loss Data...??? How to possible ??? Pleased Show me Step- by- Step.

# 1st Condition : MATCH Data 1st "SHEET 1 WITH '"SHEET 2" # 2nd Condition : "SHEET 2" MATCH DATA with other Workbook "SHEET 1" like this BOTH CONDITION MATCH AFTER SHOW ME STATUS " YES / NO " in Worksheet 2 > SHEET 1

* how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.

# How to Find particular text in Date ?????? i try to find "2021" in this cell , If Condition is " OK" and if then may be change text like "2020" this condition show "Mistake"

I was try refresh but not show data in pivot table, how to update data ...???

Hide Row with Zero value with Entry

Hi everyone, Im trying to go above and beyond by making an inventory sheet for work. I want excel to highlight the expiration dates of items that will expire in less than 30 days but I have no idea to write the formula(s). If I write out what I want to have happen it looks something like this...

Hello, I am trying to pull number string from a description text box from a very large volume of data. I have Excel 2016 Examples of cells: (THis is how my description box looks like and I am trying to extract only the bold and underline string out of each cell. all cells have dates and some...

Hey guys... How do you compute the total distance traveled by two drivers if you have the trip distance as well as the the rate per km:)

Hi there i seem to be having a problem with my "master copy template" i have an online store selling computer products. i have a list of suppliers that i work with. what i had created for me by an excel master that i just cant seem to track down is this amazing template which contains all the...