account

Hey guys looking for assistance with my countif formula. I have a number of vendors in column D and different account numbers in column C. I am looking to count all the instances of this particular vendor but only counting it once every time it hits an account. Acct are strucutre...

Kindly see if vba macro can be applied to resolve this.. As manual method is time taking. I have noted the flow of process as Go to Web site url : https://login.msn.com/ Click on sign in option Copy paste email address (eg. xxxx@live.com) from Excel cell A2 Click on Next If the error on next...

I tried to google this, but didn't know how to word it properly so couldn't find a proper non complicated solution. I have a table called 'Accounts' with all the account information. Right now when I open the userform I have: Private Sub UserForm_Initialize() AccountBox.List =...

I have a large amount of data with columns for Division, Department, and Account. I want to assign a category to every row of data based on complex criteria in those columns. Here are some examples: Category is "Absorption" if Division is not 000, Department is either 000 or in the range of...

This is long and I am sorry but I am desperate. Thanks in advance I have a control userform with various buttons to open different userforms In this case - I click the button to open the "Add New Account" userform - AddNewAccount userform opens via this code Private Sub btnNewAccount_Click()...

I am using an INDEX MATCH with INDIRECT to pull in Install Dates from another sheet based on Account Numbers on both sheets =INDEX(INDIRECT("'Master list'!F$2:F$492"),MATCH('Master Tracker'!$A50,INDIRECT("'Master list'!K$2:K$492"),0),1) We get the updated dates weekly on a sheet called...

Have setup a pivot table. Have a field of account codes under the filters area. I am able to filter on one account or specifically filter on selected accounts However I want to filter on all accounts over a certain value...

Hello, I have tried to come up with a formula for this, but keep stumbling over myself. There are 4 accounts (We will call them "Account1", "Account2", and so on) in which I need to track amounts transferred between them as well have a current total amount of each account visible. I have a...

Hi everyone, Question about conditional formatting. A have a dataset that is 6 columns of data, and I copy and paste the same 6 columns from a different data source right next to this, and then compare to see if there are differences. It works fine but where it is limited is that it is just...

I have a field in my dBase that contains the Active Directory Distinguished Name, that I need to filter on to separate account types. The data string in the field will look like this for a user account: CN=Lapp\, Lawrence E. (Larry) (TUC) ISSO,OU=Users,OU=Tucson...

Hello! I have a simple, yet not so simple problem to solve. At work we get hundreds of bank transaction files from the bank. We have an employee who has to go into each file and change the account number to the account name. This is not a value add task if you know what I mean. I know what...

This code works perfectly in the the first row only. I tried to add loop but keep getting errors. I need this move down a row and continue moving down. This is my first time doing this and I have been researching for hours. I have been using a function but i have to many conditions to list. Sub...

This is probably an easy solve, but I am a bit stumped and have tried using @if, @match type formulas and keep getting "N/A"... I have 2 tabs in excel. The first tab has over 15,000 rows of data. The 2nd tab has about 2,000 rows of data. I want to see if the account # in tab 1 is also on tab...

Hi all, I would like to use a VBA code so that to “revise” the numbers in col. “J” if the account in col. “E” is “450102 ADMIN”, “450102 RES”, “605102 ADMIN” and “605102 RES” Therefore, that should make the proper deduction and then should turn the negative number into positive. Below I present...

Hi All, This may be an impossible task so bear with me. I have the following raw data: <tbody> Owner Account ID Industry Industry# Account # Joe 1 Plumber Primary Industry Primary Account Joe 2 HVAC Secondary Industry Secondary Account Bob 3 Plumber Primary Industry Primary Account...