Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
access partition function
I have been using the Partition function in Access a lot. Is there
an equivalent function in Excel and can you please show me how to use it in Excell. Thanks, Pago |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
access partition function
Hi Sofia
You might check out the FREQUENCY and HISTOGRAM functions in Excel help. They look to be similiar to the Partition VBA function that you are using, judging by the description of Partition in VBA help. (I have never used Partition) Please note that the HISTOGRAM function is only available with the Aalysis ToolPak loaded. You obviously know how to use Access, but I do not know how familiar you are with Excel, so if you need a general discussion of using statistical functions in Excel, please see: http://office.microsoft.com/training...RC010919231033 for information on how to use Excel statistical functions. Please let us know if this helps or if you need clarification or further help. SongBear " wrote: I have been using the Partition function in Access a lot. Is there an equivalent function in Excel and can you please show me how to use it in Excell. Thanks, Pago |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
access partition function
Hi Pago,
Sorry, I used the wrong name, too many windows open, but that was the answer meant for this question. (Now I have to go find out where the Sofia window went...) SongBear "SongBear" wrote: Hi Sofia You might check out the FREQUENCY and HISTOGRAM functions in Excel help. They look to be similiar to the Partition VBA function that you are using, judging by the description of Partition in VBA help. (I have never used Partition) Please note that the HISTOGRAM function is only available with the Aalysis ToolPak loaded. You obviously know how to use Access, but I do not know how familiar you are with Excel, so if you need a general discussion of using statistical functions in Excel, please see: http://office.microsoft.com/training...RC010919231033 for information on how to use Excel statistical functions. Please let us know if this helps or if you need clarification or further help. SongBear " wrote: I have been using the Partition function in Access a lot. Is there an equivalent function in Excel and can you please show me how to use it in Excell. Thanks, Pago |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
access partition function
I believe Excel's Partition function works the same as Access's.
Sub Demo() Dim S As String S = Partition(23, 0, 100, 10) Debug.Print S End Sub 20: 29 The number 23 falls in the Range 20:29 -- HTH :) Dana DeLouis Windows XP & Office 2003 wrote in message oups.com... I have been using the Partition function in Access a lot. Is there an equivalent function in Excel and can you please show me how to use it in Excell. Thanks, Pago |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
Excel Function to Access | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |