Give this a shot.
It could be done as a nested if..then..else but for clarity, I recommend
making a custom function in the macro/vba editor.
to use, enter "=Answer(testcell) in you desired answer column, ie: in
Column C, enter"=answer(A1)".
Function Answer(MyCell)
acct = Left(MyCell, 1)
balance
presumably you want all the totals on the same line, so really just need to
find the bottom of the first column, k
The array is the column# you want totals for.
endrow=cells(65536,3).end(xlup).row
for each col in array(11,15,16,20,21)
cells(endrow+1,col).value=worksheetfunction.sum(columns(col)
On Jul 28, 7:18 am, x-plicit wrote:
> Hello All,
>
> I do not understand this sintax:
>
> =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D
> $13152)));$K$1:$L$6;2;true)
>
> Could someone help me out?
Google implies you've got a Portuguese version with =procv() being
either v
Using an approximate match, find the largest value in (B3 * C3 * each
cell in D3:D13152) located in range(K1:K6) and return the
corresponding value in range(L1:L6)
google indicates you've got a Portugese version of Excel, with
=procv() being either =vlookup().
standard layout is VLOOKUP (lookup_v
Your code is only looking at the current cell, not looping thru the
columns so this should do it.
Sub Macro1()
For Each c In Columns("A:AJ")
c.offset(-1,0).value=1
if not isempty(c.value) then c.value = (c.value
+1)*c.offset(-1,0).value
next
End Sub
However I'm unsure of your intent
I'm surely there are several workable solutions, but I would think the
easiest would be to apply the first filter, copy the resulting visible
rows to a new tab/sheet and apply the second filter there.
On Apr 7, 8:53 am, Jai wrote:
> Dear All Members.
>
> How can put the filter 2 times in One Exc
Two of Ohio's libraries have copies available for interlibrary loan if
your local community lacks it.
http://ohpir.westervillelibrary.org/search~S0?/XJohn++Walkenbach&SORT=D/XJohn++Walkenbach&SORT=D&SUBKEY=John%20%20Walkenbach/1,21,21,B/frameset&FF=XJohn++Walkenbach&SORT=D&3,3,
On Mar 24, 9:42 am
welcome to wonderful world of vba :)
Unsure such a PDF exists (least I havent come across it yet myself) -
however Excel's built-in VBA help provides a good starting place
especially when coupled with Google for more examples, code fragments,
tips/etc available from the numerous vba dedicated webs
interesting tool
please provide password to examine code so we may learn from your
example.
thanks.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/e
correct and agreed. at least the poster included the ISBN/etc info to
find it via legit sources as well.
On Feb 10, 2:38 am, Ashish Pahuja wrote:
> Hi All,
>
> I would encourage ALL users to not send pirated softwares (Paid ones) or
> ebooks (though available all over net) or their links on this
No problem. Your file already has a blank column E, so we need to
insert 3 more columns then label them.
Sub macrotrythis()
Columns("E:G").Insert Shift:=xlToRight 'insert new columns EFG
'label the new columns
Range("E1").Value = "Txn Type"
Range("F1").Value = "Security Id"
Range("G1").Value = "Se
give this a shot.
Sub macrotrythis()
'insert and label the 4 new columns --- note: your sample has (4)
columns here which I presume normally are not?
Columns("E:E").Insert Shift:=xlToRight: Range("E1").Value = "Sec
Description"
Columns("E:E").Insert Shift:=xlToRight: Range("E1").Value = "Security
Unsure, but might it be faster to save the queried results to a
temporary file from within Access then load the considerably smaller
prequeried results into Excel for its update and reporting process?
On Oct 21, 12:56 am, Holsten wrote:
> Hi All,
>
> First let me say that I love reading through
13 matches
Mail list logo