-- Forwarded message --
From: Amit Gandhi
Date: Tue, Jan 15, 2013 at 1:07 PM
Subject: $$Excel-Macros$$
To: excel-macros@googlegroups.com
Hi Experts
I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.
1. Minim
Hi Prabhakar,
paste the following formula.
=SUMIFS(C2:C10,A2:A10,"Fax",B2:B10,"Brown")
Regards
Prince
On Tuesday, January 15, 2013 12:40:13 PM UTC+5:30, Prabhakar S H wrote:
>
> Dear Team,
>
> I need to get formula for attached file. Pls help.
>
> Rgds,
> Prabhakar
>
--
Join official Fac
Hi Experts
I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.
1. Minimum of column D, H, L gets highlighted as shown above.
2. Minimum's name is mentioned against each cell in column O.
Pls see sample file attached.
Pls hel
Dear Gurus
Please help.
Regards,
Pnkaj
On Thu, Jan 10, 2013 at 5:10 PM, Prince wrote:
> Ok Pankaj
> i can only reply in evening.
>
> regards
> Prince
>
>
> On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote:
>
>> Don't use differnt mails.
>>
>> REgards,
>> Pankaj
>>
>> On Thu, J
Dear Team,
I need to get formula for attached file. Pls help.
Rgds,
Prabhakar
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Hi,
Please check Auto correct option in Excel, you can find ti in
"File-->Options-->Proofing-->AutoCorrrect Option
you will get 125 replaced with 255, delete that using delete tab (click).
Please advise if this solve you query.
thanks & RegardsRavinder Negi
--- On Tue, 1/15/13, venus wrote:
Fr
Hi Dan,
Try below mentioned code may if it can help you. replace your "searchpart"
macro with one that i have provided.
Sub searchparts()
'
' searchparts Macro
'
' Keyboard Shortcut: Ctrl+s
'
Columns("A:A").Select
Selection.AutoFilter
Selection.AutoFilter
strname = InputBox("en
Are you selecting contains option manually?
Regards
Ashish
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Dan Nichols
Sender: excel-macros@googlegroups.com
Date: Mon, 14 Jan 2013 11:45:44
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Parts search
Hi,
We are facing problem only when we input 125 and result is showing as 225.
And for other values there is no such issues we have faced yet.
And this issue is arising only on excel application and on all workbooks
that are being opened on particular system.
Regards,
Vikram Ahuja
On Mon, Jan
I am using the following macro to search a parts list
I have 3 columns.
Column A is the description
Column B is the Part location
Column C is the Part #
If I use the manual method to filter my parts by any given description in
column A. Lets say "bearing" by using the sort filter button,and t
Thank you so much
On Mon, Jan 14, 2013 at 1:22 PM, Anoop K Sharma wrote:
> Hi Jai,
>
> Please find attached file. Look at sheet2, select the country name from
> combo box at upper left corner, use spin button to change the size of shape.
>
> Regards,
> Anoop
>
>
> On Thu, Jan 10, 2013 at 3:57 PM,
On Thursday, January 10, 2013 6:33:12 PM UTC, andrew...@tiscali.co.uk
wrote:
>
> Swapnil,
>
> I have been pottering around with the spreadhseet you started for me.
> I've added a few bits in readiness for passing onto those who would be
> doing the time recording at the various checkpoints.
Sam,
You understood my problem correctly. I think rather using IF, I think we
should try for scenario. I don't know much about this.
My conditions are as follows.
1) PL are applicable after 1yr service.
2) Whoever already completed 1yr he/she will get full PL
3) If somebody finishing his 12month
Hi Prashant,
Please receive the file with solution, please revert back if you want something
else.
Thanks
--- On Mon, 1/14/13, Prashant Pawle wrote:
From: Prashant Pawle
Subject: $$Excel-Macros$$ formula required
To: excel-macros@googlegroups.com
Date: Monday, January 14, 2013, 12:19 PM
Dear
dear anoop,
Still the same problem persist. but thanks to reply my query.
Warm Regards,
Gawli Anil
On Mon, Jan 14, 2013 at 3:48 PM, Anoop K Sharma wrote:
> Without refreshing pivot, remove all the filters from the pivot and do the
> same which I had told you earlier.
> If this doesn't work the
Without refreshing pivot, remove all the filters from the pivot and do the
same which I had told you earlier.
If this doesn't work then there is no hope to retrieve all the data.
Good luck
On Mon, Jan 14, 2013 at 2:16 PM, अनिल नारायण गवली
wrote:
> dear ,
> But it only shows that much data the
dear ,
But it only shows that much data the field which i have clicked . I want
all the data.
Warm Regards,
Gawli Anil
On Mon, Jan 14, 2013 at 12:19 PM, Anoop K Sharma wrote:
> If you have pivot table existed there then double click on the grand total
> value. You can extract the pivot cache da
17 matches
Mail list logo
