Dear Team
I have a bulky database having details of Dealer, item code and Qty, I want
to make a report that which dealer has not sold which item, please help,
preferably using pivot table.
dealerItemaa1ba2aa3ca4aa5da6
Regards,
Rajender Soni
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex
Dear Amar
1. The images are there on Sheet1, You can check the same by pressing *F5
- Special - Objects*, this will work on sheet1 but will show error on
sheet2 - "No objects found".
2. By using VBA the visibility of all images in sheet1 are set to False
*(Me.Pictures.Visible
= False) *ex
Hi
The same can also be done using conditional formatting.
Regards
Rajender Soni
On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote:
> Dear All
>
> If i enter 0(zero) in any cell.it should show blank cell.
> It should not show the zero.
> lease let me know how to do it
> Tha
Dear Team
Needs your support. Please find attached two workbooks, description are as
follows:
1. *AMR FORM* - that I used to received from different locations.
2. *Database *- that is the database to store data from *AMR FORM* workbook.
I want the macro code in the *database* sheet linked to
Dear Team
Please go through the attached excel sheet and help me in the calculation of
* discount* (Column - D) based on the *discount criteria *(Column G:I)
Regards
Rajender Soni
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread t
Dear Team
Thanks for the reverts.
Please find attached the file having my requirement.
Regards
Rajender Soni
On Thursday, April 19, 2012 4:26:09 PM UTC+5:30, Soni.Rajender wrote:
> Dear Team
>
> Please find attached the excel workbook having a pivot table in one sheet
Dear Team
Please find attached the excel workbook having a pivot table in one sheet
and the relevant data in other sheet.
I want to display the top 3 states zonewise in the pivot table e.g. for the
zone - central, only top 3 states should be visible and similarly for other
zones.
Please he
Hi
The below formulae can be also used for the same:
*=IF(J5<0,ABS(J5)," ")*
**
ABS () - Returns the absolute value of a number, a number without its sign.
**
Regards
Rajender Soni
On Sunday, April 8, 2012 11:09:10 PM UTC+5:30, Aruna jayaram wrote:
> Hi
>
> Attached is a file in which in
Hi Baloo
For this you can use the concatentation of Village & dist. name.
Sheet one
Village dist State Village+Dist (new
field)
xxx yyyzzz xxxyyy
xxx ppprrr xxxppp
Regards
Rajender Soni | 750 3
Hi OPS
Simply write 1,0 in any cell, copy it, select the cell whom u want
to convert, right click --> select paste special, under paste option
select "values", In operation section select "divide", click on ok.
Regards
Rajender Soni | 7503225550
On Aug 20, 8:53 am, OPSHARMA wrote:
> Dear Ex
Hi
I think you have forgetten to attach the sheet, or the sheet was not
inserted properly, pls resend.
Regards
Rajender Soni | 750 322 55 50
On Aug 18, 10:51 am, dinoabeer wrote:
> Hi excel gurus,
>
> I need to summarize items appearing in a column. I have attached a
> sheet for your reference.
Hi
The best and the easiest way.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 12:12 am, Umesh Dev wrote:
> Hi Sundervelan,
>
> I have enclosed a file which will automatically update the moment you make a
> change in the Master sheet.
>
> Regards
> Umesh
>
>
>
> On Wed, Aug 18, 2010 at 12:06
Hi
I would suggest you to use pivot for this type of data analysis. You
can take the count of name in pivot which is what you want.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 7:34 am, Dave Bonallack wrote:
> Hi,
>
> You can use COUNTIF, which will return 1 if the id has been used only onc
Hi
You can use pivot for that.
Regards
Rajender Soni
On Aug 17, 10:51 am, Kal xcel wrote:
> Dear experts,
>
> I have SAP sales data, how to get top 10 distributor frm that huge data. One
> distributor billed many times. Is there any mechanism??
>
> Thanks in advance
>
> Kalyan
--
Hi Rajesh
We can import the data from the web,
"Click on Data Tab --> From Web" (in office 2007)
Regards
Rajender Soni
On Aug 10, 8:17 pm, Rajesh Nair wrote:
> -- Forwarded message --
> From: Rajesh Nair
> Date: Fri, Aug 6, 2010 at 1:27 PM
> Subject: CAN HTML file Connect to E
Hi Pooja
Can you send that excel file, so that our excel experts in the group
can resolve your query.
Rajender Soni
On Jul 30, 2:01 pm, Pooja S wrote:
> 2003 h/..but jo apne bataya vo already tha ..but fir b macros nai h
>
>
>
>
>
> On Fri, Jul 30, 2010 at 2:16 PM, Aindril De wrote:
> > Which
Hi
You can use the formulaes as below:
= FIND(" ",A1,1) or
=SEARCH(" ",A1,1)
Regards
Rajender Soni ! 750 322 55 50
On Jul 22, 2:48 am, Edgar wrote:
> I'm trying to clean up some data. I've used SEARCH and FIND to try to
> identify the first space within a cell, but th
Hi Preeti
Pls let us know what you want to do, or if possible please attach a
sample sheet.
Regards
Rajender Soni ! 750 322 55 50
On Jul 21, 8:31 pm, preeti vora wrote:
> Hi team,
>
> when we do vlookup is that possible without col_index_num and range_lookup
> for use vlookup..or can we use any
Hi
You can use the below code:
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\Rajendra
Soni_2\Desktop\" & Range("a1") & ".xls", FileFormat:=xlNormal,
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,
CreateBackup:=False
Regards
Rajender Soni
On Jul 20, 1:32 pm, Oliver
Hi
Simply replace "//" by "/" and do the formatting, I don't think
anything else needs to be done for this.
Regards
Rajender Soni
On Jul 20, 1:33 pm, Dave Bonallack wrote:
> Hi Deepak,
>
> Not quite sure what's wrong, but some of the data in Col C has a double //
> between the year and month.
Hi
Please visit the below link:
http://www.mrexcel.com/forum/showthread.php?t=85596
Regards
Rajender Soni
On Jul 18, 9:02 pm, Saurabh wrote:
> hi guys,
>
> need a help,
>
> i have to prepare a calender where a mail is send to a particular address (
> a...@gmail.com) on a particular date (like
Hi Harmeet
Aapke attached links padh kar maza aa gaya, its a great value add.
Regards
Rajender Soni
On Jul 10, 11:07 pm, Vinod N wrote:
> I agree with Saggi... The questions will be around Data Analysis,
> manipulation, dashboards/scorecard etc.
>
>
>
>
>
> On Sat, Jul 10, 2010 at 11:03 AM, sag
Hi Alvin
You can't close a link like that of below, please send the solution to
group, so that all members can have a look, this is only for knowledge
sharing.
Regards
Rajender Soni
On Jul 10, 7:25 am, fongie wrote:
> Hi Ramesh,
>
> I have just sent an email with an example of how this can be d
Hi
You can use the below formulae:
=IF(AND(A1=Sheet1!A1,B1=Sheet1!B1,C1=Sheet1!C1),Sheet1!D1,"not")
Regards
Rajender Soni
On Jul 15, 1:39 am, Nadine S wrote:
> I need to lookup a value based on matching 3 other columns. I do not want to
> use a concatenation and then look up that.
>
> I have
Hey Buddy,
Pls copy the below code and simply run, this will break all excel
passwords.
Regards
Rajender Soni
Public Sub AllInternalPasswords()
' Breaks worksheet and workbook structure passwords. Bob
McCormick
' probably originator of base code algorithm modified for
coverage
Hi
Not getting you, please provide a sample sheet.
Regards
Rajender Soni
On Jul 13, 1:06 am, Al wrote:
> Dear All:
>
> I get excel sheet on monthy basis . and i am trying to provide a
> summary of differences(new rows, deleted rows and changed) between the
> present excel sheet
> and the one i
http://www.familycomputerclub.com/excel/excel2003_macros.html
On Jul 12, 11:39 am, prabhakar thakur
wrote:
> Can Help me.
>
> Thanks,
> Prabhakar Thakur
> New Delhi
> +919953736776
>
> On Sun, Jul 11, 2010 at 10:03 PM, prabhakar thakur <
>
>
>
> prabhakarthak...@gmail.com> wrote:
> > Hi All,
>
>
Hi
Use the below link:
http://www.familycomputerclub.com/excel/excel2003_macros.html
the link was already suggested by one of our group member.
Regards
Rajender Soni
On Jul 11, 10:05 am, manan joshi wrote:
> try google vedio and on you tube there are lot many then you want sure it
> will help
Thanks Buddy
On Jul 11, 9:03 am, Nikhil Shah wrote:
> Dear Friend
>
> Yes.Yes..
>
> Frist visit the web site..here they have number option..Excel 2003 or excel
> 2007
>
> Regards
> Nikhil
>
> On Sun, Jul 11, 2010 at 7:13 AM, krishnan moorthy
> wrote:
>
>
>
> > Thank you Nikhil... have a quick que
Hi Bhavya
You can download the excel template for the same.
Open MS Excel
File -> New -> More Templates -> Scorecards.
Regards
Rajender Soni
On Jul 11, 9:40 pm, Rajesh Janardanan wrote:
> Bhavya,
> Dashboard cant be customised , you can have financial and non financial dash
> board with the ke
Hi
Please find below the link for MS Excel resources.
http://www.google.co.in/search?tbs=bks%3A1&tbo=1&q=ms+excel&btnG=Search+Books
Regards
Rajender Soni
On Jul 11, 8:51 pm, Iron CAD wrote:
> Dear Friends
> Please send me the excel tutorial book
--
--
Hi
Please find below the link for MS Excel resources.
http://www.google.co.in/search?tbs=bks%3A1&tbo=1&q=ms+excel&btnG=Search+Books
Regards
Rajender Soni
On Jul 11, 9:01 pm, "Rajesh.R" wrote:
> Dear Friends
> Please send me the excel tutorial book
--
---
Hi
Questions depends from company to company, however normally asked
topics are: vlookup, date, if condition, pivot table
Regards
Rajender Soni
On Jul 9, 11:27 am, ALAM wrote:
> hi!
>
> starting from into..
>
> then 1. Lookup (a,b,c)
> 2. validations
>
Hi
You can find the same under Templates section in MS Excel.
1. Open MS Excel
2. Go to File -> New -> Templates -> More Templates -> Ledgers
Regards
Rajender Soni
On Jul 8, 9:46 am, Dilip Pandey wrote:
> FYI & FYNA...!!
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),
Hi Andy
Thanks for sharing the detailed info on loop.
Regards
Rajender Soni
On Jul 7, 6:28 am, Aindril De wrote:
> Hi Venkat,
>
> *
>
> The purpose of a loop is to get Excel to repeat a piece of code a certain
> number of times. How many times the code gets repeated can be specified as a
> fixe
Hi
Please find the code below.
Sub test()
Dim one As String
Dim two As String
Dim three As String
Dim four As String
one = Range("a1")
two = Range("b1")
Range("c1").Value = ""
For x = 1 To 10
If Mid(one, x, 1) = Mid(two, x, 1) Then
Else
Range("c1") = Range("c1").Value & Mid(one, x, 1)
End If
Next
Hi
Can you pls attached a sample sheet, what you are looking for.
Regards
Rajender Soni
On Jul 7, 11:30 am, Bhawna Jain wrote:
> Hi All,
>
> Can anyone tell me how to insert sub columns under single column in an Excel
> Worksheet.
>
> Thanks
> Bhawna
--
---
Hi
You can use the below formulae for calculation as required:
=EDATE("31-mar-2011","-6")
Regards
Rajender Soni
On Jul 7, 5:21 pm, Avinash Daga wrote:
> Assuming your current date is in a1 cell
>
> =date(year(a1),month(a1)-6,day(a1))
>
> Please let me know,if this works
>
>
>
>
>
> On Wed,
Hi
Thanks a lot Aindril, the problem is solved.
Regards
Rajender Soni
On Jul 5, 4:00 pm, "C.G.Kumar" wrote:
> Please attach sample file.
>
> On Mon, Jul 5, 2010 at 2:43 PM, Rajender Soni wrote:
>
>
>
> > Hi
>
> > Pls revert to the issue below:
>
> > My rown no. is fixed - 5, column no. is cha
Thanks for the ppt.
Regards
Rajender Soni
On Jul 4, 9:18 am, Ayush wrote:
> Hi Neil,
>
> Thank you for sharing the useful file.
>
> Best Regards,
> Ayush Jain
> Group Manager.
>
> On Jul 3, 9:41 pm, neil johnson wrote:
>
>
>
> > Hi Everyone,
>
> > This is ppt of vlookup . I am very lucky , I a
Hi
Thanks for the help,
In this I want that if the user can increase or decrease the size of
the image, it will change, but next time when the image gets loaded it
should have its original dimensions, the image should live within the
cell, should not go beyond the cell's dimensions.
Regards
Raje
not clear
On Nov 2, 2:00 pm, Nagendra Modupalli wrote:
> Hi Team,
>
> Is there any formula to give cells continuous number for filter one.Thanks
> in advance.
>
> --
> Thanks&Regards
> Nagendra.M
>
> "Beautiful photos are developed by negatives in a dark room, so if U see
> darkness in Ur life b
Hi
In excel there is no DMedian function, but you can use the below code
for the same, this is an array formulae.
{=MEDIAN(IF((B1:B12=B20),C1:C12))}
Rajender Soni
--~--~-~--~~~---~--~~
-
43 matches
Mail list logo
