$$Excel-Macros$$ Scale Chart for rating

ble to make 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 thre

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 &g

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 wrote: > Hi, > > Search in google about MODI OR OCR in VBA > > Or check below link > > www.ozgrid.com/forum/showthread.php?t=147473 > >

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

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

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<< wrote: > Hi Karan, > > use this CSE formula > > > "=INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8&$B$1:$B$8=G3&H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3)))&

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 wrote: > congratulation Rajan sir. > > > > On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori wrote: > >> Congrats Rajan >> >> On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote: &g

$$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 wrote: > Congrates Rajan > > Aamir Shahzad > On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh wrote: > >> >> Congratulations Rajan Sir. >> >> Regards, >> Kuldeep Singh >

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

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

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 wrote: > *=Countif() * > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* exce

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

2 = 1 5856 = 1 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

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 wrote: > > Hi see below links: > > > http://office.microsoft.com/en-us/excel-help/substitute-function-H

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"},A1&"0123456789"))-1) Rgds Karan Singh On Mon, Sep 17, 2012 at 2:47 PM, Sundar

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 wrote: > Hi Robin, > > can use this for cleaning the number:- > >

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

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

/D Trans Amt = KES "),FIND("Tot W/D Trans Ct ",A2,1)),1)-1),"") Karan Singh On Fri, Sep 7, 2012 at 5:23 PM, Karan Singh wrote: > Hi Robinson, > > Pl. find attachment. I'v solved both column queries but what is "Tot Trans > Amt"? I was not ab

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 wro

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 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 wrote: > Hi, > > Put one single quote and then paste the value. (it is applied only past > v

$$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 violatio

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 wrote: &

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

So I would request you all to help me in this. On 4/30/12, dguillett1 wrote: > Can you just use data>filter>autofilter on the data sheet. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > From: Karan Singh > Sent: Monday, Apr

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

Hi pfa. Kaяan On Tue, Mar 27, 2012 at 9:45 AM, Ashish Bhalara wrote: > Dear finos, > > Anotherway to calculate amount. > > > On Tue, Mar 27, 2012 at 7:45 AM, NOORA

$$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 sampl