Hi Steve,
"I need an equation that will count the number of records with a name
of Jack and a state of Michigan and filter that count to a range. I
will drop the count for each range in a different cell so the equation
would be a static age bracket."
Sorry, but I can't understand the part I h
I made a User Defined Function that generates a random number from a
cumulative frequency distribution (see below). The function works
properly when the workbook is recalculated when the sheet that
contains the function is active. However, the function returns a #NUM!
if a different sheet is activ
I wrote a couple of weeks ago about converting Excel to .Txt and Mr.
Jeffries was very helpful in providing the solution. Now I have
another request. Using the same excel data as my previous example, I
need to create another .txt with a different variation.
this is what I have.
1 excel sheet
Hi
I have to send a same mail frequently to all the employee.so i need to some
macros where as i run the macro,the content to automatically apear in new mail
Thanks and Regards
Shashank Bhosle
Life is all about Uncertaity
Unlimited freedom, unlimited storage. Get it now, on
http
Hi,
I'm hoping someone can give me some assistance with getting some
information
from a Pivot Table I've created.
I'm trying to get the sum of the ST Time from my Pivot Table, however
I only
want the sum of items from the W/O# column that contain "*-010N-*".
Additionally, I need the Count of th
Exactly what I was looking for Thanks, Steve
On Apr 7, 5:55 am, Dave Bonallack wrote:
> Hi Steve,
> Try this code. It assumes data is in Columns A and B, as stated, and that the
> data starts in Row 2.
>
> Sub Steve()
> Application.ScreenUpdating = False
> A = 2
> B = 2
> C
I have a spreadsheet with 5 columns and need to count the number of
responses between a range based on the criteria of two cells.
For instance the range is A1:E16
Columns
A = Name
B = Address
C = City
D = State
E = Age
Criteria
A1 = Jack
D2 = Michigan
Count Brackets:
Age = 20-29, 30-39, 40-49,
how to bring data present in a table in word to excel. provided that
there is a list of tables in the word.
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel an
To unprotect : ExcelUtilities-including password breaker
VBA Password: Elcomsoft Advanced Office Password Recovery V4.03
Thanks & regards,
|| Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | 0321
7325277 ||
- Original Message -
From:
To
how u unprotected this file???
Wot is the mathod to unprotect a file
On Apr 6, 6:35 pm, "Mudassar Ramzan" wrote:
> Please find unprotected file and VBA password is 12345.
>
> Thanks & regards,
>
> || Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 |
> 0321 7325277 ||
>
>
Hi,
Please check the attached,
Have done it thru validation Colum B:B can be hidden if required
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of anil kumar
Sent: 07 April 2009 01:31 pm
To: excel-macros@googlegroups
Attached file has solution. Plz check validation section.
Plzzz praise me if that helps. hahahahaha
On Tue, Apr 7, 2009 at 1:31 PM, anil kumar wrote:
> Hi All,
>
> i would appricate you to all.
>
> i have a query related to Excel
>
> Example:
>
> A1100
> A2200
> A3
Hi Steve,
Try this code. It assumes data is in Columns A and B, as stated, and that the
data starts in Row 2.
Sub Steve()
Application.ScreenUpdating = False
A = 2
B = 2
C = 2
For i = 1 To 100
Do Until Cells(A + 1, 1) <> ""
Cells(B, 2) = WorksheetFunction.t
Hi All,
i would appricate you to all.
i have a query related to Excel
Example:
A1100
A2200
A3300
A4 100
A5250
A6 200
A7 300
...
A8
in above example we have data in cells A1 to A8 which have corresponding
value. now i want is that while any user
14 matches
Mail list logo
