=INDEX($C$1:$F$1,MATCH(SMALL(C2:F2,COUNTIF(C2:F2,0)+1),C2:F2,0))
On Sun, Jul 1, 2012 at 11:13 AM, Haris wrote:
> Dear friends,
>
> I want to choose the best (minimum) rate offered from 4 companies.if some
> companies not having that product i will put zero in their rate column. so
> this zero
Dear friends,
I want to choose the best (minimum) rate offered from 4 companies.if some
companies not having that product i will put zero in their rate column. so
this zero make me confused while taking min rate. so kindly check this
attached file and do let me know the solution.
With Regards,
Ha
No problem. Just to be clear it was the original suggested method that
gave the wrong day.
The format method works fine.
On Saturday, June 30, 2012 7:38:28 PM UTC-7, Asa R. wrote:
> p.s. oops, so sorry,
>
> though you had posted a new quesiton :) not sure how I got to reading old
> posts…
p.s. oops, so sorry,
though you had posted a new quesiton :) not sure how I got to reading old
posts.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Saturday, June 30, 2012 7:36 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Exce
Hi H,
.Text = bad
:)
If you mean that the date is on the worksheet as text insead of as a
date(dateserial). if the date matches the system local settings (i.e. date
is in m/d/y format, your computer is set to m/d/y format) you can just use
any of the methods I listed in my last post without any
You also might want to consider using a worksheet.change event to modify the
locked status on a given row range when and only when values in column X are
changed.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Saturday, June 30, 2012 6:
Hi Richard,
Here's my approach:
Sub prototype()
Const ColumnlarCriteria As String = "X3:X1000<>5"
Dim LockRange As Range
Dim LockRow() As Variant
Dim Row As Long
With Sheet1
.Protect userinterfaceonly:=True
Set LockRange = .Range("Y3:AX1000")
LockRow() =
Wor
Always Welcome brother..
On Sun, Jul 1, 2012 at 12:14 AM, wrote:
> Thank you Noorian sir ! Very helpful, as always !!
>
> Krishnan
>
> Sent on my BlackBerry® from Vodafone
>
> -Original Message-
> From: NOORAIN ANSARI
> Sender: excel-macros@googlegroups.com
> Date: Tue, 26 Jun 2012 13:3
Thank you Noorian sir ! Very helpful, as always !!
Krishnan
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 26 Jun 2012 13:32:38
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Is t
noorani when i use name ranges it gives me False at every row and eventually
answers gets wrong,when ever i open ur work book it gives me NAME error could
you plz send me your solve work book with correct answers?
Date: Sat, 30 Jun 2012 23:18:16 +0530
Subject: Re: $$Excel-Macros$$ tricky some
Dear Danial,
Please use
=Get.cell(21,indirect("RC[1]",) and create Name range.
then use simple
=SUMPRODUCT(($A$5:$A$9=FALSE)*(C5:C9))
or
=SUMIF($A$5:$A$9,FALSE,C5:C9)
See attached sheet for more reference.
Please revert if you have any query.
--
Thanks & regards,
Noorain Ansari
www.noo
Dear noorani,
i have attached a sample sheet hope you get idea from the given sheet,i will
have to do manual sum as i did in a given sheet and it is hectic job i have
huge data plz help.
Date: Sat, 30 Jun 2012 22:50:29 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.a
Dear Mansoor
Please share your workbook with group.
It is possible through Get.Cell Function in Excel.
On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor wrote:
>
> Dear Experts,
>
> i have 2 heads of utilities one is bold and another is in general form and
> i have a bunch of data with same forma
Dear Motilal,
Please try it..
Sub Landscap_Motilal()
Dim wb As Workbook
Dim ws As Worksheet
Set wb = ActiveWorkbook
For Each ws In wb.Worksheets
ws.PageSetup.Orientation = xlLandscape
ws.PageSetup.LeftMargin = Application.InchesToPoints(0.5)
ws.PageSetup.RightMargin
Hi Brother,
The below formula is working thanks a lot.
Have a nice day.
Regards
Lokesh.M
On Sat, Jun 30, 2012 at 8:32 PM, Rajan_Verma wrote:
> ** **
>
> Use this:
>
> ** **
>
> =IF(NOT(ISBLANK(D12)),D12+(((A13-A12)+1)/24*4),"")
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91
Use this:
=IF(NOT(ISBLANK(D12)),D12+(((A13-A12)+1)/24*4),"")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 30 June 2012 8:30
To: excel-macros@googlegroups.com
Subject: Re: F
yes thank you, now the i have changed the date format.
And one more correction if there is no user timings and macro timings the
result should be shown blank not for 4:00:00.
please do the needful brother.
Regards
Lokesh.M
On Sat, Jun 30, 2012 at 8:26 PM, Rajan_Verma wrote:
> Hi Lokesh
>
>
Hi Lokesh
You must apply [h]:mm:ss format on that cell to get proper result
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 30 June 2012 10:38
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Macro timings
Thanks Mr.Rajan, It is exactly what I want, I trying to understand your
coding.
Could you please know me the function in which data not repeat if some type
of condition is true just like Vlookup.
On Sat, Jun 30, 2012 at 5:49 PM, Rajan_Verma wrote:
> ** **
>
> ** **
>
> Try this one see the atta
-- Forwarded message --
From: jmothilal
Date: Sat, Jun 30, 2012 at 6:51 PM
Subject: Re: $$Excel-Macros$$ page setup - Reg
To: excel-macros@googlegroups.com
Sir ,
I WANT TO FIX ALL WORKSHEETS LEFT,TOP,BOTTOM,RIGHT 0.5 MARGIN
When i run BELOW code margin goes to 0.020
Sir ,
When i run this code margin goes to 0.0208 , how can i fix 0.5 inches
thanks with mothilal, also i need want fix printer area a1: h12 in all
worksheets.
[image: Inline image 2]
On Sat, Jun 30, 2012 at 10:23 AM, Lalit Mohan wrote:
> Hi Mothilal,
>
> ** **
>
> ** **
>
> Hope it helps
Hi Neeraj,
Try Out This,
Sub test()
Dim rng As Range
Dim intCountAs Integer
Application.ScreenUpdating = False
With ThisWorkbook.Worksheets("Sheet1")
Set rng = .Range("A1").CurrentRegion
For intCount = 2 To rng.Rows.Count
If InStr(1, rng.Cells(intCount, 2).Formul
Hi Ashish,
Please refer the Attachment i hope this will solve your problem.
Regards
Prince dubey.
On Friday, 29 June 2012 19:20:29 UTC+5:30, Ashish_Bhalara wrote:
>
> Dear experts,
>
> I need a function or macro to replace data from another sheets by addition
> of raw, these addition of raw is
Dear Experts,
i have 2 heads of utilities one is bold and another is in general form and i
have a bunch of data with same format,wat i want to sum data with one with
general format UTILITIES,now when ever i apply sumif and sumproduct it include
both the heads and sum both the figures number.
We have manufacturer unit and using fox base software, but now we are going
to develop software of ERP in SQL, so we are transferring data from Fox to
excel and after processing in excel transfer to SQL software of back
financial year. But now this my query is more difficult to do, so I need
your h
25 matches
Mail list logo
