ok thanks
On Monday, April 29, 2013 11:00:13 AM UTC+2, colmkav wrote:
> Hi, I am trying to execute this function to return the column number of a
> heading. However although the value is correctly 3 when it reaches the end
> of the function it becomes 0 when I set it to iFund2Col afte
File attached
--
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 thread titles, like Please Help,
Urgent,
Hi, I am trying to execute this function to return the column number of a
heading. However although the value is correctly 3 when it reaches the end
of the function it becomes 0 when I set it to iFund2Col after leaving the
function. What am I doing wrong here?
Sub test()
Dim iFund2Col As Integ
Thanks =text(cellref,"mm") appears to be the one that works.
btw, month does not as it returns just a 3.
cheers
Colm
On Friday, April 19, 2013 2:44:29 PM UTC+2, colmkav wrote:
> Hi,
>
> what excel formula do I need to convert a date field into the month number
Hi,
what excel formula do I need to convert a date field into the month number
like 03 for March?
for example cell A3= #31/03/2013#
I want "03" in my new cell.
Colm
--
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 Fac
Hi,
When I copy formatted data that has been filtered to exclude some data and
past it to a new spreadsheet the size of the new workbook is much bigger eg
20,000KB. Original had lots of worksheets and formula but still was only
2,000KB.
Why is this and how can I reduce the size? I do which t
thx
On Monday, April 15, 2013 9:58:30 AM UTC+2, colmkav wrote:
> Hi,
>
> I am trying to set the formula of a cell to be the following: =D6 &
> YEAR(MonthEndDate) & "." & MONTH(MonthEndDate) & "." & "\Outputs\"
>
> Howev
Hi,
I am trying to set the formula of a cell to be the following: =D6 &
YEAR(MonthEndDate) & "." & MONTH(MonthEndDate) & "." & "\Outputs\"
However the following code gives this forumula instead: = 'D6' &
YEAR(MonthEndDate) & "." & rg.value & "." & "\Outputs\"
How can I correct this to g
, "Wall street Jun11 future (P=62< Mar)", "Wall street Mar 10
future (P=56< Dec)" _
, "Wall street Mar 10 future (P=62< Dec)", _
"Wall street Mar 11 future (P=62< Dec)", "Wall street Mar 12 future
(P=80< Dec)" _
t;>WINST- EN VERLIESREKENING
(V&W)", Operator:=xlAnd, Criteria3:="<>"
By the way how do I filter out blanks?
thanks
Colm
On Friday, April 12, 2013 9:46:40 AM UTC+2, colmkav wrote:
> Hi,
>
> how do I exclude items using VBA code? I thought I would get the code
Seem to be having problems specifying this. I tried the following:
ActiveSheet.Range("$A$13:$T$763").AutoFilter Field:=1,
Criteria1:=Array( _
"<>BALANS - PASSIVA", "<>WINST- EN VERLIESREKENING (V&W)"),
_
Operator:=xlFilterValues
"BALNAS - PASSIVA"
thanks
On Friday, April 12, 2013 9:46:40 AM UTC+2, colmkav wrote:
> Hi,
>
> how do I exclude items using VBA code? I thought I would get the code
> using record macro but it only gave code to include items.
>
> eg
> Range("A13").Select
> ActiveShee
Hi,
how do I exclude items using VBA code? I thought I would get the code using
record macro but it only gave code to include items.
eg
Range("A13").Select
ActiveSheet.Range("$A$13:$T$763").AutoFilter Field:=1,
Criteria1:=Array( _
"10125014", "11394750", "2234200120", "2234600
Hi, I need a vlookup type function to return the value but only where more
than 1 field are the same
eg
client dateDebt
Jane 4/5/12 £50
Jabe 2/5/12 £22
So I want to get the debt value where Jane is the client and the date is
2.5.12 (ie £22)
how can I achieve this?
--
FORUM RULES
14 matches
Mail list logo
