listed

Hi Folks, I have this formula that finds one column of matches but I need a second column to also be returned. I need help in fixing this formula to allow the second column of matched info to be listed in column D if possible. Thanks Formula: =IF(ISERROR(INDEX('Analysis...

I'm a little stuck on this VBA. I currently have 100s of worksheets in a document, each with 1 column (always column A) of names. The name of the worksheet is the name of a client, and the names are who listed are who is authorized on that account. Inefficient, I know, but I didn't put this...

I have 2 sheets. Sheet1: Lists transactions in a table Sheet 2: List certain account codes. Now I want to build a macro which: Marks yellow all lines in sheet 1, which apply account listed in sheet2. (Accounts are in both sheets listed in column A)

Hi, I am brand new to this forum and not sure where to post this so forgive me if i did it wrong. I need help with a formula for a rate card for my job. I need Excel to calculate dollar amounts based on footages. The criteria are listed below. I have tried everything I know based on my limited...

Hello all! First time posting here! Just joined the site! I had a question about having a range of dates listed between two dates. For example. Lets say my date ranges are 4/18/2016 - 12/18/18, What formula can I use to have excel populate every 3 months within that date range starting with...

I have values listed as such and want to find the last data using LOOKUP( ) function THANKS ALL A B C D E F <tbody> 50000 49000 49050 55000 cv ? </tbody>

I am creating a pivot from a database of 7500 transactions spanning 13 months. The row labels are GL account #s . The column labels are Year/Month. I am getting GL #s listed twice. I have tried reformatting cells in the database, making all transactions left-justified, and copying/pasting...

My goal is to sum up the total Volume of a particular stock on a daily basis. The stock may be listed on one, or both, exchanges. If the Dates are the same, I want to add up both Volume totals; if the stock is listed on one Date only, then that needs to be shown as well. I have tried vlookup...

Hello, Help needed in a report. The data is listed in columns as indicated below. I need to generate a report showing an end of week subtotal ending on each Thursday at close of business. The fields that I need to generate by VBA are listed below the data. I need VBA to make each column and...

Hi, I'm looking to count Unique Accounts based on two criteria: Supplier and Month Accounts are listed in a data tab in column B, the suppliers are listed in the data tab in column K, and the month is listed in the data tab in column G. Here is the arrangement of the "dashboard" I'm looking...

Hello, I am simply trying to use a COUNTIF function to find a lesser than or equal to result for time. Example: I have the times 5:00 PM through 9:00 AM (descending) listed in column C. And lets say for testing purposes the exact same time frames in column B for the range. This formula below...

I feel like I should get this one, but am falling short on finding my error. I have data, listed below. My averageif formula is: =AVERAGEIF('Historical Scores'!A:A,$B3,'Historical Scores'!E:I). My understanding is: 'Historical Scores'!A:A is pulling Names, $B3 is matching the pulled name...

I would like to rearrange the order of the items listed in the menu that appears when I want to filter a list. Is this possible? For an example, if I have a column of days of the week. When I want to filter this the days are listed in the menu alphabetically, Fri-Wed. If I wanted them to...

I am new to this site so bare with me. I keep trying to attach an image and it keeps erasing my text! And it seems since I am posting this from my office that I cannot get the image to attach as an URL link. So, I will try to explain as best I can. I have 1 file with two sheets/pages...

Current data view: <tbody> A B C D E </tbody> Required data view: <tbody> A B C D E A B C D E </tbody> This is taking 5 cells listed in rows and converting to 10 cells listed in columns (1 row). Ideally the multiple of 2 (5 * 2 = 10) would be dynamic. Thanks

I have 3 tables of employees. 1. Employees who started the company 2. Employees who were recruited 3. Employees that were reinstated I want to create one list of employees. Employees can be on as many as 2 lists. I only want that employee listed once. How do I do that.

Good Morning/afternoon, What I am trying to accomplish here is rather simple but for some odd reason, I am having some difficulty with it. I have number 1-10 listed in cell A and number 11-20 listed in cell B. Now in cell D I have number 1-20 listed randomly in no particular order. Pretty much...

Hello, I have included the formulae I am using below. The one I am not happy with is the one in bold. Currently this picks up all items with a Vendor (col O) of 'CASH', but this double counts the codes listed (col H). I would like help with a formula to look at the 'CASH' (col O) and EXCLUDE...

I have a large file that is linking to a location that is no longer valid. I have gone through the database to search for that specific file link. I do not know how else to search. It is not listed in existing connections. Has this happened to anybody else & how do you resolve? Thank you.

Hi everyone, I am trying to standardize items listed in different formats (people didn't enter consistently) and can't figure out an easy way to use a function to obtain the correct formatting. See screen shot below with entry examples (column A) and needed output (column B). Is there any way to...