#excel #formula #confused

How to Highlight RAW After Bold Text ??? "E2" cell text is bold after Highlight raw on red color with white font & bold also

Hi, I'm working with stock data in excel. In the attached picture you will see 1 min high and low prices for a stock price. I'm trying to calculate the difference between the low price and high price for each bounce. For instance, since the first low happened at 11:01 AM and the first high...

This Formula use , Missing Date find perfect , but we need Find "Bill Number " , Because my file Large Amount of Bill Numbers ( May be 3000 Bill Number ) =SMALL(IF(ISERROR(MATCH($E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2,$B$3:$B$7,0)),$E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2),ROW(A1)) ( This...

How to Filter Both Pivot-table Data According After Select Drop-Downlist. "i Try select party name on drop-downlist , After filter both pivotable data on working with drop-downlist (WE NEED MULTIPLE PIVOTABLE AFTER SELECT DROP-DOWNLIST

# HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ??? We need pull data into different- different Table . Kindly Help on solve my Query, Kindly Send us Proper formula , - perfect match " HSN CODE" And pull data from TABLE1 , send to matching table

# Get data After match "Code" Both table, Need Result Table2 we need result in table1= 2.50% (Both Table Name Already in red font) How it Possible ??????

I Need Hyphen " - " Symbol via Formula, Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn

My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

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

i need only one Column , how to remove unuse area in classics pivot table ????? Show me how to delete empty column formatting

How to match Same number via join data NOTE: Not use this formula ( =+C3&" "&D3&" / "&C5&" "&D5&" / "&C6&" "&D6) WE NEED THIS PERFECT FORMULA IN THIS QUERY

@ HOW TO LOCK COLUMNS ??? I try Column " A" & "B" FIX & Lock ....... This "HSN CODE " IS EVERY TIME FIX & SAME IN BILL ......... Problem : 5 and more people use this File, So my was Change every time , i tried ... We Need lock Columns lock trick .. pleased solve my Query.

# How get Sum value via "HSN Code" vise ?????? Advance Condition : "if 100 or More Entries in sheets how it possible to solve query via Formula this Concepts " (without pivotable / without filter/ without VBA)

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