Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUM/VLOOKUP
Hi,
1, Am using this formula =IF(COUNTIF(A1:A$7,A1)1,"X","") to sum the frequency of a staff Identificaton number in terms of attendance,absentism,number of sick leave days etc how can I get it formula to sum the frequency?.CAN IT BE DONE IN VBA IF POSSIBLE? 2,I am new to VBA macros and a trying to write a cord for this formula =VLOOKUP(A1,Sheet1!A:H,3,FALSE) and would like the cord to execute from a command button on a user form.and the userform should be called when you use keyboard combination shortcut.eg(contl+A). <PLS HELP BIG TIME CONFUSED. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum/vlookup
You didnt say whether you want code to paste the function or not so you could use: Code: -------------------- Dim MyFunc MyFunc = Application.WorksheetFunction.VLookup(Range("A1"), Sheets("Sheet1").Range("A:H"), 3, False) MsgBox MyFunc -------------------- sonto;196601 Wrote: Hi, 1, Am using this formula =IF(COUNTIF(A1:A$7,A1)1,"X","") to sum the frequency of a staff Identificaton number in terms of attendance,absentism,number of sick leave days etc how can I get it formula to sum the frequency? CAN IT BE DONE IN VBA IF POSSIBLE? 2,I am new to VBA macros and a trying to write code for this formula =VLOOKUP(A1,Sheet1!A:H,3,FALSE) and would like the cord to execute from a command button on a user form.and the userform should be called when you use keyboard combination shortcut e.g. (CTRL+A). <PLS HELP BIG TIME CONFUSED. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54176 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUM/VLOOKUP
I'd be tempted to investigate use of the FREQUENCY FUNCTION. This is an
array function so takes a little getting used to. Check out the WORKSHEET FUNCTION news group... "sonto" wrote in message ... Hi, 1, Am using this formula =IF(COUNTIF(A1:A$7,A1)1,"X","") to sum the frequency of a staff Identificaton number in terms of attendance,absentism,number of sick leave days etc how can I get it formula to sum the frequency?.CAN IT BE DONE IN VBA IF POSSIBLE? 2,I am new to VBA macros and a trying to write a cord for this formula =VLOOKUP(A1,Sheet1!A:H,3,FALSE) and would like the cord to execute from a command button on a user form.and the userform should be called when you use keyboard combination shortcut.eg(contl+A). <PLS HELP BIG TIME CONFUSED. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup problem - unable to get the vlookup property | Excel Programming | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |