card

I have a spreadsheet that is full of credit card application dates. Chase has a rule where it will automatically decline a credit card application if you have received more than 5 credit cards, from any institution, in the last 24 months. With that said, I want to do a formula to figure the...

I am using a VLookup drop down menu that by selecting any of the numbers 1 through 109 it would then display the data of that card in sheet1 (SPPLAY ) that consist of 13 different categories on that card itself. The VLookup chart is located in sheet 3 (FAC2). My problem at this point is I...

I have a very long list that I run a macro for. I need the total credit cards (Visa + Master Card + American Express) for that day. On top of that I am running a Macro and the date range is different every time. I think I need a formula that consolidates the "Date" Column so it doesn't repeat...

So I need help, I am looking to speed up my time card and have it autofill the dates on my time card when input the weekending date. I can forward you the spread sheet if you want so you can see what i am working with. Thanks, John

This one is a hard one to articulate so I'll do my best. Also, please tell me if this is easier in Access. I have a set of transactional data that has card number and merchant. I want to only display merchants (ideally in a pivot table) that all of those card numbers have been to and exclude...

Hello. I am building a call center agent score card. on sheet 1 I will have my report data pasted in. On sheet 2 I will have a score card template in place. In the first box I will have a data validation box set up with a list drop down of all of the agents. In all of the other boxes on the...

good day thanks for looking do some can see whats wrong with this formula it seems that I have been watching it too much and can't find the issue for not working =IF(OR($B48="Withdrawn",$B48="CREDIT CARD"),IFERROR(VLOOKUP($Y48,'EFT Information'!$A:$L,13,0),"Not EFT"),"Not EFT") <tbody>...

Hi Experts, I have data like the table below, where I want to fetch time (Column C) when the Emp Code 843567 swiped his card on 05/23/2018 for first and last time between time interval 6:00 AM and 3:00 PM. <tbody> EMP Code DATE CARD SWIPE TIME 843567 05/23/2018 6:10 AM 674593 05/23/2018...

<tbody> A B C D E 1 PRODUCT Q1 Q2 Q3 TOTAL 2 VOLUMES - SUPPLIER 1 1 2 60 3 VOLUMES - SUPPLIER 2 1 25 4 5 (On separate worksheet) SUPPLIER 1 SUPPLIER 2 Q1 50 45 Q2 5 8 Q3 15 25 </tbody> Hi - can anyone assist, what...

Hello there, I have a file set as the table below. I want to be able to change the "(3)" to any given number in one cell, doing so in all cells, but no the actual card number. I want the setup to be like the 1:st column, and not like the 2:nd. Might add that these cells are not connected to...

Hi all, Apologies if this has been answered somewhere else but if it is, I can't find it. I'm setting up a budget spreadsheet where I download all of my transactions from my bank and run a little macro that automatically categorizes all of my transactions based on an existing table. So for...

Hi. I have a macro that selects multiple sheets and is supposed to be applying formula's to all sheets. However, the formula's are only being applied to half the sheets and I don't know why. I am not getting errors when it's selecting the sheets and I can see that all sheets are selected...

Hello, I have a pretty complicated requirement and need some help. My business users receive a credit card file from our vendor and use this file to reconcile against data that is loaded into our financial application. The file has no column titles however has several different header...

In Cell. B4 (.221) is pitchers season batting average against. In A10 (.259) Is the league batting average, . If 50 percent of results come from pitchers card, what formula would calculate what pitchers card would be in order to average .221 (B4) against a league average (A10) .259. Thanks for...

Hello all! I have an event that require card access to validate attendance. Note: The card scanner populates cell B2 and overwrites the same cell after every scan. <tbody> A B C D E F 1 ID SCANNER SCANNED ID NAME 2 9000 8000 BURNO 3 Y 9000 JAMES 4 5000 ADAM </tbody> When...

Hello all! I have an event that require card access to validate attendance. The card scanner populates B2 and overwrites after every scan. <tbody> A B C D E F 1 ID SCANNER SCANNED ID NAME 2 9000 8000 BURNO 3 Y 9000 JAMES 4 5000 ADAM </tbody> When there is an ID match...

good day, i'm trying to convert our family business stock card to excel but having difficulties, exactly i have no idea on what formula should i use to achieve this, here are a few details on our stock card <tbody> date inventory in inventory out Stocks on Hand 12/25/2017 44 44 12/26/2017...

Hi I am importing a report, however sometimes there is a large space within the heading, eg..."Account_Number ", sometimes there isn't, eg..."Account_Number" Rather than having to change the code every time to accommodate this space, is there a wild card I can use in VBA? Hope...

Hello guys Kinda new to the forum. Ive been looking for a multiple bingo card tracker for my parents since they love playing it so much. I came across this file but do not know how to use it. Can anyone please help? TIA here is the file...

Hi everyone, I am happy to join to such wonderful forum. I will really appropriated if you could help this issue. I have the following table <colgroup><col></colgroup><tbody> <tbody> Day Amount Means 1 143 Bank 2 22 Cash 3 1980 <tbody> Master Card </tbody> 4 5 Debt Card 5 388...