Search results for query: *

Ok I'm stuck and need some assistance. I have a spreadsheet that has invoice numbers in column A and the reason the product was returned in Column B. Some invoices appear more than once on the sheet depending on how many products were returned on that invoice. I'm trying to find invoices...

I have an existing report that I need to add headings to for all the fields on the report. There are dozens of fields and the spacing is bad between the fields so I can't easily see the field names. Is there a way to add the headings for all fields at once so I can export it to Excel and get...

Awesome! Thanks - works like a charm.

I have a string of data in cell A1... XXX.AD1212,super,6ft,black I need a formula to move the last word in this string to cell B1. Here's the kicker...sometimes there will be commas separating the data in the string, sometimes it will be spaces, and the number of commas and spaces will vary...

Using Excel 2007... I have a spreadsheet with 3032 rows of text in column A. I'm repeating row $1:$1 on all pages. There are 10 columns (A thru J) on each page and 47 rows including the row I'm repeating on all pages. What I want to do is move cells A48:A93 to B1:B47, A94:139 to C1:C47, etc...

Thanks. Worked like a charm!

SELECT Inventory.Location FROM SQLUser.Inventory Inventory

I want to create a drop down list from a named range. This named range will be a list of inventory locations from an ODBC query into my inventory. Problem is, I need this list to only show unique values. Also, I have the ODBC query set to automatically refresh upon opening the spreadsheet so...

Column A will not always equal column G. I'm attaching the spreadsheet so you can see what I'm working on. I know the index and match formula will work - I just can't figure out how to do it.http://www.homesintheshoals.com/Customer_List.xlsx

I have a spreadsheet I need some help with. I'm pretty sure I need to use the index and match functions but I can't figure it out. I have a list of customer numbers in column A and in column G. If the customer numbers in these two columns match, I need to replace the customer number in column...

I have a spreadsheet that shows sales information for the 3rd quarter of 2012. Each row of data shows a customer number, customer name, address, city, state zip, and sales total for each invoice. What I need to do is group this data by customer number and show the total sales for each...

Ok. Thanks for the reply but need some help as I'm not too savy with Commands. Here's what I've done thus far... I created the command and it compiled and I ignored the link warnings. I have the command in my list of database fields and I have created a dynamic parameter pulling in the field...

I have a parameter where I need to include a NULL option into the dynamic parameter. The field that includes the NULL values is a string. For example, I want the Available Values option of the parameter to show... NULL Andy Jeff Bill Carl Eddie

I have a customer who has two printers, one is a thermal label printer and one is an Okidata 320 dot matrix. Both printers are physically installed on Windows XP Pro SP3 PC's and are shared. They have an inventory management system installed on a Windows 7 Professional 64 bit PC and both of...

In column A, I have employees like AMY, DANIEL, etc. I have the spreadsheet sorted by Column A so I need a page break between employees so each employee has their own page when the spreadsheet is printed. I thought about doing a query on individual worksheets for each employee but was hoping...

Is there any way to insert a page break when the data in cell A1 changes (except for the header of course)? This is data being pulled from an ODBC connection to a SQL database and will be run on a monthly basis so when the worksheet is refreshed, I'll need the page breaks to automatically shift...

Thanks Brian. That works but the results aren't always going to be numeric. Some will end with one or two characters so it's returning incorrect data on those.

Where {@part-IC_fron_text} is mid({Sheet1_.Text},44)

On your second formula, I could do another formula on the same text field like... left({@part-IC_from_text},4) and then concatenate them back together to give me my results. Do you see an easier way?

The first formula is returning the following error..."Start position is less than 1 or not an integer". I used the following formula.... //{@takemiddle} numbervar hyp := instr({Sheet1_.Text},"-")-3; numbervar spa := instr({Sheet1_.Text}," "); MID({Sheet1_.Text},hyp,spa) The second formula...