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...

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...

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...

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...

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...

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...

Using CR11...have a text field that I need to extract a section of data out of. Below is an example of the text field as well as an example of the data I need to extract. Text Field Example 1 CONVERTED Part Sale... Yard# 1 Store# 1 U 601-58797 Retl$ 50.00 Qty 1 Stock# 5895 Core$ 0.00 Text...

Hello all. I'm developing a workbook that shows all inventory entered. I'm connecting to my system using an ODBC connection pulling all inventory into a single worksheet that refreshes automatically after 5 minutes or upon opening the workbook. What I want to do is seperate the data from the...

I've got a pivot table that I want to assign parameters to. I can accomplish this if I do a normal data query and then base my pivot table off of it but I was wondering if this can be done if the pivot table is created directly from the external ODBC data source. I need two parameters - a...

I'm working on a report pulling data in from an ODBC connection to a SQL database. I have some fields that show a duration of time in seconds. For some reason, when I add those fields to the report and run it, the fields are showing a larger amount of seconds. However, if I refresh the...

I have a numeric field {Warehouse.Duration} that contains seconds. I need a formula to convert this field to show days, hours, and minutes. Here's what I have thus far: //{@Duration_Calc} WhilePrintingRecords; NumberVar TotalSec := {Warehouse.Duration}; NumberVar Days := Truncate...

Have a field with the following value... ACURA LEGEND I want to remove ACURA and the space before the word LEGEND so the formula returns only LEGEND. I know how to get just ACURA... if {Inventory.Model} startsWith 'ACURA' then left ({Inventory.Model},6) else {Inventory.Model} but can't...

I have the following formula but there won't always be data in each of the 6 fields. What I want is to remove the rows in the formula where there is no data. {WOSummary.AcctNumtoShip} + ChrW(13) + {WOSummary.CustomerShipTo} + ChrW(13) + {WOSummary.ShipAddress1} + ChrW(13) +...

I have a field in a database that currently shows, for example, the following: 92-95 AEROSTAR (FORD VAN) or 99 BUICK LESABRE If the field contains like 92-95, I need a formula to convert the years to show 92 93 94 95 and extract them so only the years show without the make/model info.

I have a duration string field that shows: "3 Hr, 27 Min" or "20 Min". I need a formula to convert this field to a field that will show "03:05" for 3 Hr, 5 Min or "00:20" for 20 Min. I need to do an average sum on this field so I can show an average duration.

I'm having issues with this formula. It's showing left and right correctly but all are showing front. He's some examples of the data in the two fields... {Inventory.Side} LH RH {Inventory.Description} LH, FRONT RH, REAR {Inventory.Type} FRONT REAR if {Inventory.Side} = "LH" or...