Random Card Dealings
Aug 9, 2009I want to take random card dealings like in example:
So, 52 cards for 4 players. It doesn't matter where from formula takes values. Here is (yellow) just example in one column...
I want to take random card dealings like in example:
So, 52 cards for 4 players. It doesn't matter where from formula takes values. Here is (yellow) just example in one column...
I have a sheet which details specific card numbers in Column A, and the date and place of transaction in the Column B. This very long list contains multiple entries for each card number. What I would like to do is use Sheet2 to list each card number and the number of times it appears in the list.
View 4 Replies View RelatedI am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.
View 2 Replies View Relatedbtw i saw following soloved post but i didnt get the question and answer.
can u provide examples?
http://www.excelforum.com/excel-misc...ard-count.html
I am trying to put together a userform based time card calculator. User inputs the time in the time out and how long of a lunch. Then the program will display total hours worked for the day. Ive attached what I have so far. The only thing that is not very clear is that I have one hidden textbox for the lunch. It is there only for calculating and the visible one is going to inc by :15 min.
View 9 Replies View RelatedIf any excel expert who know how to compare names that are similar to one other with a wild card,
for example
A
COLUMBUS STEEL CASTINGS CO. 2ND LIEN (AKA BP METALS)
B
BP METALS AKA COLUMBUS STEEL Total
A
LS POWER - BROADWAY GEN FUNDING LLC
B
BROADWAY GEN FUNDING, LLC Total
My live sheet is a lot more complex but this will help me well on my way.
Ill let the example say everything:
Sheet3
ABC1Condition 1Condition 2Condition 32red lorrybig £ 92,621.98 3yellow carbig£ 145,498.33 4yellow vanbig£ - 5pink carsmall£ - 6red carsmall£2,552,404.50 7pink lorrybig£ 862.37 8green carbig£ - 9green lorrybig£ 707,083.31 10red vansmall£ 30,010.73 11green carbig£ 2,276.13 12 13 14Total of all cars that are big: 15expected answer £ 147,774.46
Excel tables to the web >> Excel Jeanie HTML 4
Data in B2 looks like this: "[13.0]DEV;[13.0]AUDIT" or can be "[13.0]DEV"
I need to wild card B2.
Although, not working.....my formula looks like this:
=if(and(A2="audit",B2"*"&"[13.0]AUDIT"&"*"),"Closed Audit",A2)
I have a database which holds a field for people's credit card numbers. When I try to import them into excel it removes the last number and replaces it with a 0. So if I have credit card number 123456789123456 it will show as 1.23456E+15. Then when i format it as a number is shows as 123456789123450.
View 11 Replies View RelatedI have a scorecard created in excel 2007. All my end users are using excel 2002. Now I want to build a scorecard in Excel 2002 like what we have in excel 2007. Is it possible.
I want to display the traffic signals and 5 level indicators (arrows), based on conditional formatting.
This is out of box in excel 2007. But how do I achieve this in excel 2002?
Is there a simple method?
How to get the card# from staff ID as lookup value? ask.PNG excel question.xlsx
View 6 Replies View RelatedIm trying to use a wild card to count the number of cars regarless of color (Red, Blue and Black) in Maryland which are USED.
A: Cars Red, Cars Blue, Cars Black.
B: State
C: Type: NEW, USED
So I tried
=SUMPRODUCT((A2:A3100="Car~*"),--(B2:B3100="Maryland"),--(C2:C3100="USED"))) and tried with countif
=Countif(A2:A3100="Car~*"),--(if(B2:B3100="Maryland"),--(if(C2:C3100="USED")))
Just basic enter a start time in column A a finish time in column B and column C gives you total in hours and minutes and then maybe a way to sum those hours and minutes. how to do "Math" on time and how it should be entered (formatted) for it to work properly.
View 4 Replies View RelatedSuppose the data is:
beaut* 1
abc* 2
and I use the command:
Vlookup("beautiful", A1:B2, 2, false)
I want this formula to return 1. I have done it before, the other way around when the wildcard is used in the formula but not in data.
I was wondering if there was a template in excel 2003 that could be used for printing on a 3x5 index card. if so,e finding it or setting it up?
View 6 Replies View RelatedHeres My Code...
Code:
Sub HideDatedSheets()
Dim wb As Workbook
Dim ws As Worksheet
Dim dDate As Date
[Code]...
So what im trying to do is keep the Union* sheets shown as well as the Report* sheets shown. But i believe i have the code wrong because they are not showing up when the work book opens...
Trim(ws.Name) = "Union*" Or _
Trim(ws.Name) = "Report*" Or _
How do I format a spreadsheet set up as a time card entry log so that I can enter 0543 and it appears as 05:43 AM and/or enter 1653 and it appears as 4:53 PM.
I have it formatted right now to show that data but I have to enter it as 05:43 and it appears as 5:43 AM which is what I want and the in/out times calculate with an end result of hours worked.
I want to do it without having to enter the colon.
I'm trying to use the COUNTIFS function & have run into trouble because the 2nd criteria is a date. Typically I would just set the range & then put "01/01/2014" if I was looking for all of the January 1, 2014 cells. However in this spreadsheet my source data contains the date with the time. (01/01/2014 11:27:39 AM). Becasue the time is included in the cell, the function returns no results when I set teh date.
I tried to use a wild card "01/01/2014*" which I thought would bypass the time but it still retuns no results. Is there a way to use a windcard with a date cell?
I have a workbook containing 2 sheets. In the first sheet I have a list of values, let's say that the list contains names:
Worksheet1
Column A
Peter
Paul
In another worksheet I have another column, also containing names:
Worksheet2
Column A
James Harrow
Paul Givens
I wish to perform a vlookup in worksheet2 but cannot use wildcards in the table array :
Vlookup ("*"&ColumnA&"*";Table1[Table or table and column];1;false). What I want should look like the following: ("*"&ColumnA&"*";"*"&Table1[Table or table and column]&"*";1;false)
In this problem, it is not appropriate to query back to front; i.e. vlookup worksheet1 instead of vlookup in worksheet 2.
I have seen an interesting post that uses macros (on this site, I think) but was not able to implement it.
I am trying to put together a userform based time card calculator. User inputs the time in the time out and how long of a lunch. Then the program will display total hours worked for the day. Ive attached what I have so far. The only thing that is not very clear is that I have one hidden textbox for the lunch. It is there only for calculating and the visible one is going to inc by :15 min.
View 10 Replies View RelatedHow to use VB to get the name off the CAC card to verify their identity?
View 1 Replies View RelatedThe usage of the wild card character is not getting me the results I need for a formula I am using at work. When the wild card asterisk character is removed, I get the correct result but only for an exact match of the particular text. I need it to match the "Particular Text plus another text. The Text is CBKC. Then there is also CBKC 5400 and so on. I need to have the wild card expression character before and after the CBKC characters. The formula is below that I used.
=sum(--k2:k500),--(c2:c500=" Y"),--(D2:D500=" Permit"),--(s2:s500="*CBKC*))
Excel doesn't like the way I am expressing the wild card inside the double quotes......the column getting added if the matches are found is column K. The other columns have to meet the criteria in the formula.
I have a userform capturing Credit Card Numbers for Visa, Master, Amex and Diners as part of a payment tracking system and would like to check that the entered Card Number is valid before processing the payment through a third-party website to minimize to number of error / invalid card messages.
I suspect there is some kind of checksum built into the cardnr. Any tips on how to check for the validity would be appreciated, including links to relevant sites.
this question is related to an earlier question of mine: [url]
We have agreed maximum rates with suppliers for certain services and I'd like to check that the rates they have invoiced fall below the agreed maximum.
I've attached an example of the data I'm working with. What I'm after is a formula that will cross check the details and rate charged on the 'Invoiced' tab against the three 'rate card' tabs and generate an output that flags any discrepancies. I've added a column called 'Validate' on the 'Invoiced' tab where I'd like this formula to go.
All the data should match with the exception of the shift which is listed as a description on the rate card but is a concatenation of the job role and an abbreviation of the shift (D = Days, N = Nights/ Saturday and O = Sunday/ Bank Hols).
I have a lot of information for various contacts, in the following format:
Name: John Smith
Address: 123 Spring Street
Phone: 555-5555
Email: example@example.com
Name: Jane Doe
Address: 456 Elm Street
Phone: 555-5555
Email: example2@example.org
Name: Richard Roe
Address: 10 Bridge Street
Phone: 444-4444
Email: example3@example.org
What I am trying to do is convert that information so that it looks in a spreadsheet as follows:
example.jpg
I feel fairly sure this is the kind of thing Excel is capable of doing, but despite much searching and experimenting can't figure out how to do.
I have the need to filter out letters put in after a number in a time card spreadsheet. I'm not sure that using a select case is the right approach. I need to allow the user to put in a number and a letter signifying what type of time it is. Each cell equals a date on a calendar. For example if the user puts in 8s then the code will add 8 hours to the total sick time, strip out the s and just leave 8 in the cell. The problem is that I need to deal with all of the other letters/symbols that they can enter. From what I know of VBA which isn't much a Select Case seems to be way to go without using a bunch of nested If statements. Here is what I would like to do but this doesn't work. This is a short example of what I have tried as far as Select Case goes.
View 6 Replies View RelatedI am looking to copy a simple board game in Excel
Basically it would be a simple race. Containing 4 counters (blue, green, red and Yellow) and 10 squares each.
There would be 40 cards 10 blue, 10 green, 10 red and 10 yellow. Cards would be draw randomly and the counters move respectively. I would be thinking about starting with =RANDBETWEEN(1,10).
I have no knowledge of VBA/ macro but would welcome ideas with what formulas/ commands to use.
I have added some snapshots to show what I would be looking for.
[URL]
I need to extract the credit card expiration date from a cell. For example
1111 1111 1111 1111 1/17 code 1111
I was able to get the /17 using =MID(C77,FIND("/",C77),4)
However, I can't get the "1" before the /.
I need to add small trendlines next to some data in a score card and also working out the calculating Compounded Annual Growth Rate.
1) how do i just extract the treadline, i have created the graph but don't know how to just extract the trendline
2) is there a simple calculation on excel to work out the CAGR?
Golfers have a numeric handicap based upon their proven ability (reported scores); the lower the handicap, the better the golfer.
My golf group is randomly drawn into handicap-balanced foursomes. If 24 guys are playing, six teams are created as follows:
1) The six players with the lowest golf handicaps are "Captains," and are randomly drawn.
2) After the Captains are drawn, the six players with the next lowest handicaps are then randomly drawn as the #2 players for each team.
3) The same process is followed to randomly determine the #3 player and #4 player for each team.
If the number of players is not divisible by four, some threesomes are then created, and one, two or three players are then on two teams. e.g., If we have 29 players, we draw 5 foursomes (20 players) and 3 threesomes (9 players). In this event, each threesome will use the scores of a randomly drawn player (Ghost) from one of the five foursomes.
(Each Threesome's "Ghost" player should be drawn from the group [captains, #2's, #3's, #4's] which will best round-out and handicap-balance the team.)