Re: $$Excel-Macros$$ how to count names

Hi, You can use a Pivot table to get unique names. Please let me know if this answers your query Thanks Prashanth On Sun, Feb 6, 2011 at 7:15 PM, niru wrote: > I have one query for one database. I have few numbers of names i want > to count that. if there are 1 name nitin repeated 5 time and

Re: $$Excel-Macros$$ Help: powerpoint shortcut

Hi Janet, The shortcut for Powerpoint through run is --> powerpnt Thanks Prashanth On Thu, Jun 24, 2010 at 10:51 PM, janet dickson wrote: > Hi Team > > *Sorry for asking this in excel group.* > > Does any one know the Shortcut for opening a MS Powerpoint using run box > (Winkey + R) ?? > > I ca

Re: $$Excel-Macros$$ Re: text and date in one cell

t; Let me know if solves your query > > Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On 11/12/09, Prashanth Banneni wrote: >> >&g

$$Excel-Macros$$ text and date in one cell

Hi All, Can you help me how to get the desired output from the attached sheet. Many thanks in advance Best Prashanth -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-

$$Excel-Macros$$ Getting top 50 ranks from a pivot table

Hi Group, I Have a Pivot table with Ranks data. Now i want to get Column wise 1.Top 50 Ranks(Only), 2. their title, 3.Country and 4.date. Please let me know if you want it in the excel sheet for better understanding. Can you guys help me with this. Thanks In Advance Prashanth --~--~-~

$$Excel-Macros$$ Re: pdf to xlsx

Hi Mahesh Able2Extract_1_.Professional.v6.0.0.0 would help Thanks Prashanth On Fri, Sep 18, 2009 at 1:35 PM, Mahesh wrote: > Dear Team, > > Is there any software to convert a pdf into excel? > if yes, please provide. > > -- > With Love, > Mahesh Bisht > > > > --~--~-~--~~-

$$Excel-Macros$$ Re: find & replace Suffix / cell

Hi Manoj, Let me know if this answers your query. Thanks Prashanth On Fri, Sep 11, 2009 at 7:28 PM, Manoj Kukrej wrote: > hi, > > > > Pls find the attached sheet > > I want to put suffix/ prefix in the require cell > > > > Regards > > > > Manoj > > -- > This e-mail

$$Excel-Macros$$ Re: Appending formula

"BBB", C16="CCC"),"High",IF > (D16 > Regards, > V Ravi Kumar > > On Sep 14, 10:18 am, Prashanth Banneni wrote: > > Hi All, > > > > I have a query, which needs to be appended. > > > > I have this formula in column F which shows th

$$Excel-Macros$$ Re: Auto complete list popup windo in excel

Hello Dilip Sir, If there is data in the same column above then Press Alt+ Down Arrow. This will show the list of the unique values above. As i am a beginner in excel Let me know if this is a valid sugestion. Thanks Prashanth On Tue, Sep 1, 2009 at 10:36 AM, Dilip Pandey wrote: > Hi Vidyut

$$Excel-Macros$$ Re: Hii..

Hi Ruchi, Type this in B1 =A1&" "&A2&" "&A3 Thanks Prashanth On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena wrote: > Hi Friends, > > I have data in three cell > > A1= My Name > A2= is > A3= Ruchi > > can i have a formula wherein the below info in cell A1,A2 & A3 appears in > *single cell * > > i.

$$Excel-Macros$$ Re: Make a Pivot Table using data from 2 different worksheets

Hi Daniel, Thanks for the Update. However there is no scope for me to pull the data from Access as the data is in excel. Can you please help me to make a single Pivot from the data in 2 different worksheet. Thanks, Prashanth On Tue, Jul 14, 2009 at 5:55 PM, Daniel wrote: > > Hi. > Have a look

$$Excel-Macros$$ Make a Pivot Table using data from 2 different worksheets

Hi All. I have data in two different sheets. How do i make a Pivot Table using data from 2 different worksheets. Please Help...Very Urgent Regards Prashanth --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Help on copying formula.....

Hi, You can use =$A1 and drag it across columns Cheers Prashanth On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL wrote: > Hi All, > > Genrally in spreadheet, if you copy a formule in other rows, formula is > changed according to row number. e.g. we have a cell with formula ""=A1" and > now we

$$Excel-Macros$$ Re: Urgent Excel Help needed

> I have sent your solution on your mail id. > > > > Pls check it. > > > > On May 29, 11:26 am, Prashanth Banneni wrote: > > > > > Hi All, > > > > > I have a issue with excel. Hope you can solve it easily :) > > > > > I have a

$$Excel-Macros$$ Urgent Excel Help needed

Hi All, I have a issue with excel. Hope you can solve it easily :) I have a list with start date and and end date. Once i select the start date and end date the range if dates should be shown in the Row 10. Is it possible using formulae's because the file is too heavy and might crash if we incl

$$Excel-Macros$$ Access query-very urget please help

Hi All, I have a small query in MS Access. I have 2 tables 1.Test1 2.Stable The title column in Test1 table have few titles which are same as Title column in STable. I want to lookup the title in STable and update the Scolumn in Test1 Table with Yes or No. That is if the Title is present in STa

$$Excel-Macros$$ Re: single password for excel

Hi all, Can any one give me the password breaker tool. Thanks in advance Regards, Prashanth On Sat, May 2, 2009 at 3:06 PM, girish gv wrote: > post the file i will break the password > > On 12/19/08, jasm...@1908 wrote: >> >> HI there,…. >> >> >> >> Send me the file and I will break the pas

$$Excel-Macros$$ Urgent Help in Access

Hi All, I have an very urgent issue with MS Access, however it might be simple to you guys. Please help me, very urgent. I have two tables: Test1 and Month I want to update column Month1 from table Month to Month column in table Test1. primary key is on WeekNo. I tried the following ode and i

$$Excel-Macros$$ Filter Pivots

Hi All, I have an issue with the pivot tables filter, as i need to change the filter in as many as 10 sheets(20 pivot tables) to get the correct values. Is there any way where i filter it in one page and the remaining pivots change accordingly. Appriciate an early solution from you. Thanks in a

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

Hi Lavprasad, You are awesome. Thanks a million. Prashanth On Thu, Apr 9, 2009 at 4:38 PM, Lavprasad Kori wrote: > > Hi Dear, > > Attached herewith the file of soluiton. > > Regards, > > Lavprasad > > > > On Thu, Apr 9, 2009 at 12:54 PM, Prashanth Banneni w

$$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph

Hi All, Any help on this please. guess you understand the urgency. Thanks, Prashanth -- Forwarded message -- From: Prashanth Banneni Date: Thu, Apr 9, 2009 at 11:09 AM Subject: Convert $900,000 to $900k in graph To: excel-macros@googlegroups.com Hi Team, I have an urgent

$$Excel-Macros$$ Convert $900,000 to $900k in graph

Hi Team, I have an urgent requirement. i have a graph whose y axis has revenue from $0 to $900,000, now i want to remove the last 000 and show as $100K, $200K, $300K, $400K..$900K. Can any one let me know how to change it in the custom tab under Format Axis. Need this help for a presentatio

$$Excel-Macros$$ Re: pivot table help

Hi, I was looking similar sheet where we can calculate productivity and attendance of individual employee. If any on has information please let me know. Many Thanks, Prashanth On Tue, Mar 31, 2009 at 6:28 AM, Norman May wrote: > Ankur, > > Here is a link to an attendance sheet I made. > I'm n

$$Excel-Macros$$ Re: Convert pdf to excel

Dear Manoj, I downloaded the software kindly provide serial key for full version. Thanks in advance. With Regards, Prashanth On Mon, Mar 23, 2009 at 9:59 AM, nehal sejpal wrote: > Dear Manoj, > > I already download the software kindly provide me the PIN No.Thanks in > advance. > > With Regards