Extract Negative/Positive Value in Excel by Min-Max Formula (Excel in Hindi)

Here in this video, i have explained how to separate negative value and positive value in different cells. To separate the negative and positive value we have used =MIN & =MAX formula.

Download Practice Sheet Here:


▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

(1) Excel की सारी वीडियो यहां पर देखें

(2) Tally की सारी वीडियो यहां पर देखें

(3) Pivot Table की सारी वीडियो यहां पर देखें

(4) Macro की सारी वीडियो यहां पर देखें

(5) Tally TDL की सारी वीडियो यहां पर देखें

(6) Online Tricks की सारी वीडियो यहां पर देखें

(7) Sponsored की सारी वीडियो यहां पर देखें

(8) Gadgets Review की सारी वीडियो यहां पर देखें

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
My Social Media Links:

(1) Excel Expert's Facebook Group

(2) LinkedIn

(3) Facebook Page

(4) Twitter

(5) YouTube

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Contact for Business Inquiry :

Channel Owner: Nazim Khan
🏆 Experience: 10 Years+

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

#TechGuruPlus #NazimKhan

[SKumar-nmrz]

Bahot achha sir
Dashboard sikhne ke liye kuch video banaiye plz

[Noumanjavedshamsi]

Sir this problem mine was too but couldn't find the solution you solved it by telling thanks sir

[gulapagarwalla]

Really useful.. thanks alot.. deserves more subscribers

[shahanimhj]

sir achi video hy, Sir next video, aik to" inventory management system", aur dosri video cell highlight in color (conditional formatting) per zaror banayn please

[ranjan]

Hello sir, I want the min value in difference column and want to display negative numbers only, but my first-row difference is having a positive number, so how can I take this into consideration?

[mstraders]

Dear Nazim Khan please create a huge video on power query in excel

[Atique_salat]

Pls. Download the video of 256 excel command keys. I will be very thankful to u.

[manglesh]

Sir blinking cell par bhi lecture dal skte he?

[manglesh]

sir odbc wala aapka lecture dekha, setting bhi ki pr wo ho nhi paa rha

[kishoredas]

Sir agar koie cell me value -20 hye to upper kay cell me 1 hoga, 1 dal ne bad vi agar negative value raha to fir 2, fir neg to 3 aysa bartha jayega.. aysa koie formulla haye to bathana

[ariankumar]

Sir good morning I am Ravi Kumar from siwan how to create Ledgers and cash book our received & payments and balance sheet in Excel formats

[shahanimhj]

MashaAllah achi video hy sir ismy aik cheez ka izafa kerdyn k min wala cell red ho jay aur max wala cell green ho jay ya koee sa bhi color aajay automatically

[azhadshamim]

Assalamu alaikum,
Sir,
Plz a video for the short or excess formula in same column
Example
Item-1 system qty 100 pcs but physically count is 99
Item-2 System Qty 100 but physically count is 101
So once I put physical count in the excel sheet should show the difference between System and physically count
Thank you

[pardeepmani]

Sir ek column m 1 to 100 value hai like 2-, 20-, 40-, 44-, aise he value hai, numeric value k baad negative hai.postive karna ka ways.

[Tanveerkhan-scjf]

Kabhi kabhi excel file web se download karte hai to usme error aata hai use kaise hataya jata hai ya fir hide error ko kaise hatayenge.? is par ek video please

[nayanrathod]

Hii I have one question
1) how to find out 1 highest, 2nd. Highest, and 3rd highest minimum negative value from particular column.??
Waiting for reply.
Thanks

[AgrianDashrath]

If formula for_ if range between -1 to 1

[navedkhan]

Sir Receive Value Positive Show Ho aur Pay Value Negative uske liye kya formula rahega

[punitranjan]

Dear sir,
I want average of four number excluding upper and lower number.
Example
10, 20, 30, 40
Average is 25

[Sunnyhindustani]

SIR AAP NE ITNA SARA TDL UPLOAD KIYA H PER EXCEL TO TALLY WITH INVENTORY KA KOI TDL NHI H
PLZ UPLOAD SIR