I have list of people that I am constinly putting into different spreadsheets for various reasons. I want to be able to set up a drop down menu that lists...

My function: =VLOOKUP(G7,"Asset"&F7,1,FALSE) "Asset"&F7 is a concatenation for a named range. If i type in manually, it works. Concatenated, it does...

Hi All- I need help returning a list of names on a separate sheet. I'll enter "manager 1" in an input cell, and i want to return a list of corresponding...

I have the following function and it is only half working for me as my arguements seem to contradict one another as I want to see if my number falls within a...

I am trending a bank account balance. Every time I enter the current value in cell c3, I would like it to update the value in the next empty cell in range...

I have an application where I need to update cell B5 in Sheet 1 with a cell value from a specific cell (C4) on Sheet 2. The issue is that in this instance, I...

Hi Guys I need an array formula which counts the number of instances range Comp1 has a value greater then zero AND Range Comp2 has a blank value. Sounds...

Hi In 1 sheet have 20 tables of holding the same except for col 1 in each that hold a unique id for that table. Each table can hold up to 50 rows, so some...

Hi everyone 1. I'm looking for something in VB that will save a copy of my workbook "in the background" to another location on a network drive. 2. During...

I have merged cells across the bottom of a worksheet for a comment area. I have formatted the text to wrap. How do I get the area to auto format the height?...

I have a 2 part question. I want to have a 1 question survey randomly filled out by 200 people. Column A lists the 1 questions. Columun b has ABCDE listed...

Dear experts, Jacob Skaria, MVP wrote me a marco below for the solution of conditional formatting on autoshapes. As Jacob's macro refers the value of A1 to...

I am doing a catalog merge in publisher. Data is in XL. Publisher has 255 character limit on merged info. How do I count the characters before I execute the...

What would be the format of the IF/AND/OR nested statement to return the following: If R1 contains a 9 and S1 contains a 36 I want a 4 in T1 If R1 contains...

I need some help creating a function or formula in Excel for the following: • Example: payment amount is $2,589.32 Run a tape: 2+5+8+9+3+2 +...

I am currently using 2007 - I have about 20,000 rows by 12 columns of information in a spreadsheet. Column "G" cells will at times have more than 1 number in...

I want to convert a spreadsheet that has 9 fields into a block of text. From this in Line 1 in an excel file (9 fields): 300 Shady Grove 15720 Shady Grove...

I have a list of number: -17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3 The sum of those number +1 is the answer to the current number, but what...

I have a matrix of data that lists part numbers in row and serial numbers in column as shown in Example 1. In the example below (Example 1), the range...

Hi I tried to post this once so apologies if this is second post... I want to count the number of times 3 or -3 occurs in range A8:A15 depending on whether 3...