accounts

I know there are great plug-ins for Fuzzy Lookups on Windows machines but I work in a Mac office. I have 3 cols of data: Col A = My accounts Col B = Each account's point of contact Col C = Attendee list I want to know if an account I own in col A is in the attendee list in col C but there...

Hi, I have a table with accounts stating with numbers from 1-9. I want to take a sumif of column h, off all accounts starting with 7. I have setup the following SUMIFS formula but it is not working: =+SUMIF('ABSL NEW'!H:H,"7*",'ABSL NEW'!A:A)

I have the following measure which is returning 100% for every row. Voucher Spend as Pct of GL:= [Voucher Amt] / CALCULATE ( [Voucher Amt], ALLSELECTED ( Vouchers[Account] ) ) Voucher Amt:=SUM(Vouchers[Voucher Amount]) What I would like is for when I select certain accounts that the measure...

I have a lists worksheet with an account listing in A13. In my Master worksheet I have an account column with that account name in cell A18. In the details page that account doesn't display in the accounts column I entered =Lists!A13 in cell A18 on my Master worksheet, the account name went...

Hi there, I've been going round in circles trying to figure this one out. I have to show on a graph staff on leave during a certain period, including how many per team. I'm looking for a graph with staff names on the vertical axis and each date on the horizontal axis then a plot mark showing...

Hello, I have an email database where it contains lot of Yahoo, Hotmail, Gmail and other email accounts in 1 column.. I want to filter and put the domain on the 2nd column. So for an example:- outlook.com, hotmail.com, live.com email accounts should be named as HOTMAIL in front. (2nd column)...

Hi All, I need your expertise help with this please! Work has tasked me with an excel spreadsheet and I've played around with it, but can't get it to function properly and need someones help with more knowledge. What they want is a master spreadsheet of supplier payments for the year (April...

I have a data set of accounts which is about 20 columns and 800 rows (could be more or less depending on the month). The data is extracted from another program/server, then saved to excel. In column "C" I have business names. I am trying to identify which business names are for the same account...

Hi, I have a list of 300 accounts in the first columns and the contacts in the second column. Each account can have multiple contacts to it so it will appear in rows multiple times: Company1 - email@email.com Company 1 - email2@email.com Company 2 - email@email.com Company 2 - email2@email.com...

hey so after my amazing first experience of someone answering my question id thought id ask my 2nd question but i think that this is gonna be more complex within my data i have unique Ids for example my title heading is ID , then i have id's such as 1000, 1002 1001 1000 1000 some appear in...

My spreadsheet has 20 rows and 20 columns containing accounts receivable information. I then have the same grid for accounts payable information. Below is a simplified version. I want to, as easy as possible, list the differences from what each company shows as a/r compared to what the...

Dear Guys, Hi...... I Need formula to know find the specific date of absent in one cell for an employee... Kindly advice me... Note: A-Absent P-Present WO-Week-off Waiting for your soon reply. I given below my attendance sheet format. Kindly Update...

I just upgraded to Windows 8 and my accounts receivable software is no longer supported by the operating system. I was hoping to create a workbook in Excel that can achieve the same results as my software. I have a list of clients and I.D.'s matched to them that I have already set up into the...

I need some help. I have an Excel workbook in which one spreadsheet "Budget Expenses" contains invoices that were paid and are entered as they are received (in no specific date order). The spreadsheet also contains the amount paid, and the account number it came out of. For example: On...

Hi, I need an excel file that can keep track of fundraising events (what each student made for their account during a fundrasiser) and then take that total and put it onto their separate account on another sheet. I think it is pretty simple, but I don't know enough about Excel to do it. So you...

I work in a call center. I have a hot boss that I'd like to impress. ;) Anyways, She spends an hour a day turning a huge list of accounts, into smaller lists for 20 people to work. I'd appreciate it if someone could help me impress her and save her TONS of time. Here's the problem: I have...

hello frnds i am new to excel n i m using office 2010 plz can u help me in creating a debit credit sheet with dynamic functions step up step, cause i only know to fill the data in the sheets and nothing else. i have details of columns as follows with every column having a label A...

Hi everyone, I am currently running a children's Xmas tree in my workplace. the old Treasurer has resigned (in Jan 09) and has finally passed the Accounts spreadsheet over to me. It is an sheet that appears to have been developed many years ago and has the following attributes (used loosely)...