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

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

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

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

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

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