Search results

Hi Expert Can i highlight the duplicate using CF,I know how to highlight duplicate if value is single,but problem is i have 2 value with delimited with "/" Few examples for your reference,see highlight with RED Invoice No DODI18090410 DODI18090410 DODI18100200&DODI18100393...

updated with raw data

File Attached

Hi!!! I have data Zone, Outlet, and Sales and I Create Pivot Table from this Data I need those Top Outlet who have Contribute 50% of the Total Sales against Each Zone. For example, if Zone A has 10 Outlet and their Total is 127, what I need to highlight or who have achieved 50% from the...

Thanks a Ton Dear This is what i am looking

Hi Thanks for the Reply I am Attaching the Sheet for better Clarification Conditions are : 1: If R5 is Equal to J3 and K3 than Calculate the 9% of H5, L4 Remains "0" 2: If R5 Is Equal to L3 than Calculate the 18% of HG, J4 and K4 remains "0"

Hi!! I am using IF formula using Drop Down. Drop Down List 1: SGST/CGST 2: IGST Other Condition in J3,K3,L3 i.e. SGST@9% CGST@9% IGST@18% RespectivelyNow i am using below Formula for IGST@18% its working and calculate the Value fine Formula is for IGST@18%= =IF($R5&"@18%"=$L$3,$H5*18%,"0")...

That's Cool

Thanks for the reply Thanks for the reply but its not working m getting below result after Change the Value to DAY(TEXT(TODAY()-3 Updated Joyride Program Summary Till Dated - 23th-Jul-2017 Cumulative

Thanks for the reply but its not working m getting below result after Change the Value to DAY(TEXT(TODAY()-3 Updated Joyride Program Summary Till Dated -23th Cumulative

Hi All i have formula "="Updated Joyride Program Summary Till Dated -"&TEXT(TODAY()-1,"DD-MMM-YYYY")&" "&"Cumulative" and the result is " Updated Joyride Program Summary Till Dated -25-Jul-2017 Cumulative " What i need to Add "th" or "rd" after the Day For Example 23rd or 25th or 22nd...

omg, How should i Forget Sum product Function Thanks a Lot Mike

Thanks Shaikh Saab Kamal Kar diya aapne to, Thanks again

Hi All, Is there any way for get the Value in another Table or Sheet, Using Vlookup or Index match Function Where the Criteria is More than 1

Thank U Sir, Its Works Perfectly ,Thanks a Lot

Man , U R Actual a Excel Ninja ;) Let me Experiment in my Actual Sheet, Will Let u know, in case of any Discrepancy Thanks for your valuable Solution

Hello Experts Attached is my Master Data Just an Example Now, what i need to Update Fee Agnt Every Student Date wise in Sheet2,When I Put Vlookup In Sheet 2 The Result is Same in All Cell Match with Master Sheet

Hi I have Number in a A1 Say, 1667511 What i Want to Display the Number 1667511 into RS. 16,67,511 Regards Hardeep

Hi! Experts In column A i have Dates with different Format. Like Dates 28/08/09 05-09-2009 8.27.2009 8.27.2009 8.27.2009 8.29.2009 25/08/09 25th Aug 31.08.09 2nd sep 2nd sep 4th Sep Now i want to Change this Dates of MM-DD-YYYY FORMAT. When i change the Whole Columnn i.e...