$$Excel-Macros$$ Scale Chart for rating

the scale chart. ​Thanks​ Karan Singh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Dynamic Charts

Hi, Pfa. Thanks Karan Singh On Fri, Jan 25, 2013 at 1:51 AM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hello Group, I want to veiw table 1 data in graph when check box is true else table 2 data when check box is false. -- Regards Santosh santoshkumar.subu...@gmail.com

Re: $$Excel-Macros$$ File conversion from BMP to XLS !!!!!

Hi Indrajit, Try from this link : http://www.onlineocr.net/ Thanks Karan Karan Singh On Sat, Dec 8, 2012 at 12:08 PM, XLS S xlst...@gmail.com wrote: Hi, Search in google about MODI OR OCR in VBA Or check below link www.ozgrid.com/forum/showthread.php?t=147473 Sent from my iPhone

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

Congrats buddy! :) Karan Singh On Tue, Dec 4, 2012 at 8:59 AM, p.dhamsa...@gmail.com wrote: ** Congrats paul... Sent from my BlackBerry® smartphone from !DEA -- *From: * Ayush Jain jainayus...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Mon

Re: $$Excel-Macros$$ Find value on duplicate and two conditions

Thanks EB..! Karan Singh On Wed, Nov 14, 2012 at 7:32 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi Karan, use this CSE formula =INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8$B$1:$B$8=G3H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3))) -- *Regards,* * * *Excel

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Congrats dude!! Karan Singh On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan neerajchauhan...@gmail.comwrote: congratulation Rajan sir. On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori mori.gov...@gmail.com wrote: Congrats Rajan On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain jainayus

$$Excel-Macros$$ Remove All Special Characters

Dear All, I need to clean all special characters from a my data. Please suggest any formula or macro to remove them. Please find attached sheet. Thanks Karan Singh -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

Congrats dude! Karan Singh On Wed, Oct 3, 2012 at 10:24 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: Congrates Rajan Aamir Shahzad On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Congratulations Rajan Sir. Regards, Kuldeep Singh Back Office

Re: $$Excel-Macros$$ Forecasting, Budgeting Variance Analysis

Thanks Kuldeep! Karan Singh On Fri, Sep 28, 2012 at 12:18 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Karan, See below links: http://www.cimaglobal.com/Thought-leadership/Newsletters/Insight-e-magazine/Insight-2012/Insight-January-2012/Spreadsheet-skills-Modelling-Actual

Re: $$Excel-Macros$$ Serial Number with Duplicate Values

Thanks to all for the great ideas suggestions. Regards Karan Singh On Tue, Sep 25, 2012 at 7:12 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *=Countif() * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel

$$Excel-Macros$$ Serial Number with Duplicate Values

2556 = 1 2556 = 2 Thanks Karan Singh -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ subtitute function infirmation required

Please find below : http://blog.contextures.com/archives/2011/01/28/30-excel-functions-in-30-days-27-substitute/ Karan Singh On Wed, Sep 19, 2012 at 11:23 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi see below links: http://office.microsoft.com/en-us/excel-help/substitute

Re: $$Excel-Macros$$ Convert to number

Hi Robinson, Use =trim(your number) Regards Karan Singh On Mon, Sep 17, 2012 at 12:41 PM, Robinson Boreh rbo...@gmail.com wrote: Dear members, I have an excel sheet with numbers, but they contain a non numeral character at the end and i can not therefore sort nor do any mathematical

Re: $$Excel-Macros$$ Convert to number

Hi Robin, Rather than using my earlier solutions use below one : =trim() copy paste as value Convert to Number. Regards Karan Singh On Mon, Sep 17, 2012 at 12:52 PM, Deba Ranjan drdeva...@gmail.com wrote: Hi Robin, can use this for cleaning the number:- =IFERROR(CLEAN

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

Dear Sundar, Please use below formula : =LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10123456789))-1) Rgds Karan Singh On Mon, Sep 17, 2012 at 2:47 PM, Sundarvelan N nsund...@gmail.com wrote: Hi Friednds, Please help me to extract only text from alphanumeric word for example NT2 = *NT

Re: $$Excel-Macros$$ Separate figures from text

Hi Robinson, Pls use below formula and drag it down or Ctrl+D for Tot Dep Trans Amt : =SUBSTITUTE(MID(A2,FIND(KES ,A2),LEN(LEFT(A2,FIND(CHAR(10),A2)-2))-FIND(= ,A2)),KES ,) Rgds Karan Singh On Fri, Sep 7, 2012 at 3:34 PM, Robinson Boreh rbo...@gmail.com wrote: Dear Members, I need

Re: $$Excel-Macros$$ Separate figures from text

Singh On Fri, Sep 7, 2012 at 5:23 PM, Karan Singh karan1...@gmail.com wrote: Hi Robinson, Pl. find attachment. I'v solved both column queries but what is Tot Trans Amt? I was not able to understand that. I'v done this with lots of logics, because I'm a learner not expert :) Ask experts

Re: $$Excel-Macros$$ Data validation solution

No, middle column is not necessary, I just put it for you. Yeah! Arun's method is right, he's told as I did. First Select all cells put formula Ctrl+Shift+Enter. Karan Singh On Fri, Aug 24, 2012 at 12:01 PM, amar takale amartak...@gmail.com wrote: Thanks Karan But middle column

Re: $$Excel-Macros$$ Error! Pasting more than 15 digits

Thanks Sara Kuldeep for the suggestion. I need to paste value in bulk Sara I fixed it from your method. Thanks Karan Singh On Tue, Aug 21, 2012 at 4:37 PM, Saravanan Anna sarvananar...@gmail.comwrote: Hi, Put one single quote and then paste the value. (it is applied only past value one

$$Excel-Macros$$ Graph Query

Dear All, I want to create a graph as shown below. Is there any way to to create chart like this. I tried my best to search and create this but I couldn't. Please help me to create this graph. Thanks Karan Singh www.KagGran.com -- FORUM RULES (986+ members already BANNED for violation) 1

Re: $$Excel-Macros$$ Need help to make good format of report

would request you all to help me in this. On 4/30/12, dguillett1 dguille...@gmail.com wrote: Can you just use datafilterautofilter on the data sheet. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Karan Singh Sent: Monday, April 30, 2012 7:21 AM To: excel

Re: $$Excel-Macros$$ Need help to make good format of report

Thanks Noorain for replying, but I'm not able to understand this file. I would request you all to solve my problem with combo box, I would be very thankful to you. Kindly solve my problem according to my format. Thanks Karan Singh On Tue, May 1, 2012 at 12:49 AM, NOORAIN ANSARI noorain.ans

Re: $$Excel-Macros$$ vlookup with more than one value

Hi pfa. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts On Tue, Mar 27, 2012 at 9:45 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear finos, Anotherway to calculate amount. On Tue, Mar 27, 2012 at

$$Excel-Macros$$ Conditional Chart

Dear All, Is there any way to make a conditional chart. I need to make a conditional chart. Kindly help me in this. conditions 1. If value is Less than 40 = bar graph colour : Blue 2. If value is 41-70 = bar graph colour is Green 3. if value is 71-100 = Red I'v attached the file for the