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

$$Excel-Macros$$ Re: How to get max number from a database ?

Hi All... Thanks a lot for the reply. :) Regards Karan On Wednesday, 9 January 2013 15:35:50 UTC+5:30, karan wrote: > Hi > Can anyone pls let me know how do i get the max value or date (using a > formula and not pivot) from the database that i have. > > Attached

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

Re: $$Excel-Macros$$ Vlookup

I have done as said still the function is not working. So i want to know where am i going wrong? I have send u the screen shots on ur email as i dont know how to attach files on these grp Thanks, Karan On Dec 2, 8:15 pm, Sam Mathai Chacko wrote: > Karan, sure I will try to help, but what

Re: $$Excel-Macros$$ Vlookup

Dear SAM, I have created the addin from the above trailing mails. Can u please guide me where am i going wrong or how to use it once the addin is created? Please help On Oct 27, 1:59 am, Aamir Shahzad wrote: > *Done SAM*, wonderful thanks for your cooperation. I think I must have to > save this

Re: [bulk] $$Excel-Macros$$ Extract Text

p://karanxel.blogspot.com/> <http://karanxel.wordpress.com/> On Tue, Nov 1, 2011 at 3:33 PM, Siraj Momin (BTG) wrote: > PFA > > ** ** > > Best Regards > > ** ** > > * * > > Momin Siraj Ahmad > > ** ** > > *From:* excel-macr

$$Excel-Macros$$ Extract Text

Dear All, I've around 8k cell which has data showing below, I need your help to extract specific text from the string. I need to extract text after first comma ( *,* ) & before left paranthesis as showing below. Kindly help. Govt College of Engineering, Wayanand, P O Nallurnad, Mananthavady (19

Re: $$Excel-Macros$$ FW: Village

Amazing..!! Kaяan On T

Re: $$Excel-Macros$$ Extract (Text & Numbers)

Thanks a lot neil but there is a query (Pincode) which has not solved yet. I've to extract Pin Code from the text as I'v written on mail & worksheet. Kindly help me in this. Thanks Kaяan

Re: $$Excel-Macros$$ Extract (Text & Numbers)

p://karanxel.blogspot.com/> <http://karanxel.wordpress.com/> On Thu, Oct 20, 2011 at 9:57 AM, karan 1237 wrote: > Dear All, > > Hope you all are doing well..! > I need your assistance to sort out my problem. I need to extract Pincode, > Principal Name, Establishment. I'v

$$Excel-Macros$$ Extract (Text & Numbers)

Dear All, Hope you all are doing well..! I need your assistance to sort out my problem. I need to extract Pincode, Principal Name, Establishment. I'v attached the sheet. Kindly help. Thanks Kaяan

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Anil, Convert your image files in excel through online or download a software from the website below : http://www.onlineocr.net/ http://www.cometdocs.com/ http://www.coolutils.com/Online-Excel-Converter.php http://document.online-convert.com/convert-to-pdf http://www.pdfconverter.com/

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Anil, Please find enclosed. Kaяan

Re: $$Excel-Macros$$ can we change hard copy in excel

Yes you can convert your image files in excel through online or download a software from the website below : http://www.onlineocr.net/ http://www.cometdocs.com/ http://www.coolutils.com/Online-Excel-Converter.php http://document.online-convert.com/convert-to-pdf http://www.pdfconverter.com/ http:/

Re: $$Excel-Macros$$ Shortcut key for Border

Hey Ankit, Please see below image : For all border press Alt+H+B+A For outline border Ctrl+Shift+& & for all border commands press Alt+H+B+ then press character which is showing in the image below: [image: Picture1.jpg] Kaяan

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

Hey Waheeb, Pls find enclosed. Kaяan

Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT solution needed!

Hey Shane, If your workbook size is more than 10 MB, you can compressed its size through this : Save as or press F12 >From "Save as type" drop down & save your file in Excel Binary Format. Just try this. Kaяan

$$Excel-Macros$$ Extract 6 & 7 Digit Number

Dear All, Hope you all are doing well ! I need your assistance to sort out my problem. I need to extract 6 & 7 Digit number from the string. Example : I. C, Rajendra Palace, New Delhi 110053 II. C, 301 Rajendra Palace, 110053 New Delhi III. C, Rajendra Palace, 110 053 New Delhi *Result : * I.

$$Excel-Macros$$ Extract (%) Numbers from the text

ult should be : 50% I've attached the file, Please find enclosed. Thanks Karan Singh <http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237> <https://plus.google.com/43524614789164919/posts> <http://www.myspace.com/singhkaran> <htt

Re: $$Excel-Macros$$ Transpose Data from cell to columns

p://karanxel.blogspot.com/> <http://karanxel.wordpress.com/> On Tue, Sep 13, 2011 at 9:08 PM, NOORAIN ANSARI wrote: > Dear karan, > > By Excel > Use formula *=SUBSTITUTE(A1,CHAR(10),"-") * in second Column, and Copy and > Paste it as value, then normal you can use Tex

Re: $$Excel-Macros$$ Transpose Data from cell to columns

ps://plus.google.com/43524614789164919/posts> <http://www.myspace.com/singhkaran> <http://www.linkedin.com/in/singhkarann> <http://karanxel.blogspot.com/> <http://karanxel.wordpress.com/> On Tue, Sep 13, 2011 at 4:14 PM, NOORAIN ANSARI wrote: > **Dear Karan, > >

$$Excel-Macros$$ Transpose Data from cell to columns

Dear All, I'v to transpose data from a cell to columns. Please solve my query. Thnx in advance Kaяan

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

I knewcongrats Rajan..!!! You are great...!!! ~~~ Karan www.karanxel.blogspot.com ** On Thu, Aug 4, 2011 at 9:50 AM, Dilip Pandey wrote: > Congratulations Rajan...!! > > Regards, > DILIPandey > > On 8/3/11, Ayush Jain wrote: > >> > >> Hello Everyo

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

Hello friends, Please find attachment of array & simple formulae. Thnx Karan www.karanxel.blogspot.com * Kαяαη* On Tue, Jul 26, 2011 at 12:27 PM, Venkat CV wrote: > Dear All, > > any one Explain Difference between Array formula and Normal Formula... > > With Exam

Re: $$Excel-Macros$$ Merge Vertically

* Hey friend, I facing this problem. I want to merge all columns in one time. Kαяαη* On Fri, Jul 15, 2011 at 2:56 PM, NOORAIN ANSARI wrote: > Dear Karan, > > Please try it > > Sub mergecell() > With Selection > .HorizontalAlignment = xlGeneral > .Merg

$$Excel-Macros$$ Merge Vertically

Hello Friends, Once again I need your help. There is option for merge across in excel but is there any macro to merge vertically. It will merge selected range in vertically. Thnx Karan -- -- Some important links

Re: $$Excel-Macros$$ Need a Macro

It's working...Thank you so much... * Kαяαη* On Fri, Jul 15, 2011 at 12:33 PM, NOORAIN ANSARI wrote: > > http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html > > > On Fri, Jul 15, 2011 at 12:29 PM, karan 1237 wrote: > >> Hello Fr

$$Excel-Macros$$ Need a Macro

Hello Friends, I need your help to make macro. I need a macro which work like format painter for different format not only one format. * --- Kαяαη* -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Numbering

Hey ankur, I want to ask something Sub test() Sheet1.Range("A2:A15").Clear Dim i, j As Long Range("a1").Value = InputBox("put your value") For i = 1 To Sheets(1).Cells(1, 1).Value Cells(i + 1, 1).Value = i Next i End Sub In this code what is "i" & "j" ? * Kαяαη* On Mon, Jul 11, 201

Re: $$Excel-Macros$$ Need a book

s@googlegroups.com] *On Behalf Of *karan 1237 > *Sent:* Tuesday, July 12, 2011 2:32 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need a book > > ** ** > > ** ** > > Hi Group Users, > > > I need your help, I need a book of excel *&qu

$$Excel-Macros$$ Need a book

Hi Group Users, I need your help, I need a book of excel *"101 secrets of a microsoft excel addict".* If you have full version of this book please send me. Thnx Karan -- -- Some important links for exce

$$Excel-Macros$$ Need a book

Hi Group Users, I need your help, I need a book of excel *"101 secrets of a microsoft excel addict".* I you have full version of this book please send me. Thnx Karan -- -- Some important links for exce

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

It's great...!!! *--- кαяαηη* On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Congratulations Ashish Koul....!!!

h Sir who has created this group. Thnx Karan Singh karanxel.blogspot.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our L

Re: $$Excel-Macros$$ Automatically Hyperlink

Thnx again to all of you for solving my problem. You all are great! *--- кαяαηη* On Tue, Jun 7, 2011 at 4:39 PM, mohd saber wrote: > Hi Karan, > > please find attached file with the result. > > i have included one formula in the same sheet for your reference. > > t

$$Excel-Macros$$ Automatically Hyperlink

Hello Experts, I need your assistance. I'v a workbook which has 4 sheet. I want to create a automatically hyperlink (through formulae) when I change content of cell a2, hyperlink automatically should change...Please help me. Thnx *--- кαяαηη* --

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

t all vba cod and passwrod request will not work than sheet > will open and go to refrance pswlist and you will show all pass and than go > to vba auditor and show code and user form > thx and best wishes > gomaa. > > > On 2 June 2011 14:24, karan 1237 wrote: > >> Thnx a

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

Thnx a lot Rajan. You are most helpful persongreat... :) *--- кαяαηη* On Thu, Jun 2, 2011 at 5:37 PM, Rajan_Verma wrote: > Hi Karan, > > I think it has been Complete Now…. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

Thnx a lot Rajan but I want one more thing that is it possible to make input box character like dis *. If it is possible so please help. Thnx *--- кαяαηη* On Thu, Jun 2, 2011 at 11:59 AM, Rajan_Verma wrote: > HI Karan > > See it help > > > > Rajan > &g

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

can protect ur > project with a password.* > > ** > Regards > Vishal Gupta > > > > On Wed, Jun 1, 2011 at 3:58 PM, karan 1237 wrote: > >> >> Hello Expert >> >> I need your help to to create conditions & password protection in my >> pr

$$Excel-Macros$$ Please help to make my project good.

Respected Sirs/Mam, I need your help making my project good. Please find attachment. I will be very obliged if someone can help me as earlier as possible. -- Basically I have to do that when I click on drop down list & select another career i.e. Building and Construction so In sub career

Re: $$Excel-Macros$$ Please Help

quot; > End If >Next Cel >If Len(Tx) > 0 Then Tx = Left(Tx, Len(Tx) - 2) >If Len(Tx) > 0 Then Tx = Right(Tx, Len(Tx) - 2) >UniqueList = Tx > End Function > > > > On Sat, May 7, 2011 at 3:50 PM, karan 1237 wrote: > >> * >>

$$Excel-Macros$$ Please Help

* LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT *Hi Experts, I want like this. Please help. Thnx in Advance. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- ---

Re: $$Excel-Macros$$ How to Separate Text and Nos in a sentence ?

Hi Thanks for the formula. It does help, but while trying it on a new sheet its not working it gives an error #NAME? On Apr 19, 9:07 pm, ashish koul wrote: > see if it helps > > > > > > On Tue, Apr 19, 2011 at 7:14 PM, karan kanuga wrote: > > Hi, > > &g

$$Excel-Macros$$ How to Separate Text and Nos in a sentence ?

Hi, Can any1 pls let me know how do i separate the text and nos in a given sentence. PFA the sheet where i need to separate the nos and text. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITT

$$Excel-Macros$$ Pls Help...

*Hi.. Experts & Excel guru I need ur help.. pls help me.. Thnx Karan * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and l

Re: $$Excel-Macros$$ Pls Help..

*Thnx.. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı On Thu, Feb 24, 2011 at 10:15 AM, Rohan Young wrote: > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > 2011/2/23 кαяαηη yα∂αν > > >> To post to this group, send email to excel-macros@googlegroups.com >> > >

$$Excel-Macros$$ Macro Help

Hi guys i m trying to make a macro but i m not able to get it can any1 help me in making a macro. I need a macro whcih gives me the foll : 1)the cel in whcih i press the macro short cut - it should add 8 - 10 lines above that cell and then, 2)on that 8 - 10 lines it should have the foll : MP