I am trying to create a new column in my pivot table that calculates the relationship (a ratio) between two previous columns. Those two columns are...

=TEXT(LOOKUP(10^10,MID(A1,1,ROW(INDIRECT("1:"&LEN(A1))))+0),"000") "JJ" wrote: I have data as this format: 025BNN, 033WGN, I want to get only the numbers...

I want to retrieve a set of data from one spreadsheet based on multiple search criteria into another worksheet. For example, I work in manufacturing and I...

Please help how to create and use macro codes for a Button. (never used macro before) need a button in cell T4 and need these cells (below) to reset to...

Can someone can help me??? I need a VBA code that will say… if value of cell A2 is equal to “x� then copy G2:P2 to worksheet “test2� if value of...

In Office2007 - how can I do my own design on a toolbutton assigned to a macro, as it was possible in Off2003?

can anyone help on this: lets say i have a cost for an item in c2, its inventory age in c3, and a price column in c1. can i formula so that when i enter 1...

Good afternoon all, I have an excel problem I could do with some direction with. Basically This is a work in progress but once this one piece is sorted I...

Previous staff have form the function below and I don't understand what it means. He was no more longer work here. I need someone to explain what it...

Ok I have a worksheet that I enter all my daily information into for my job. In one column i enter either J or R to let me know what type of transaction it...

Hello, Am new to all this but this is what am trying to do Sheet 1 - list of retail products Sheet 2 -another list of Retail products but they have...

I am creating a cost matrix that identifies a cost estimate of doing a certain task within certain perimeters. In the future, when our base costs change, I...

I am using arrow keys on the keyboard to see and edit through the excel sheets. When i click the arrow keys on the keyboard, instead of the focus getting...

how do I write a formula for if b4 is between 1 and 100 then good or between 101 and 200 no good or 201 and 300 stop? Thanks

Hi folks, Is it a way to get its k-value from percentile and array. Thanks. PeterK

Very similar to hours:minutes:seconds: http://support.microsoft.com/Default.aspx?kbid=213449 -- Gary''s Student gsnu200709 "HARSHAWARDHAN. S .SHASTRI"...

I need to link to several slightl;y differing workbooks Using Indirect I can pick up the data where the cells are fixed. However, some data moves around...

Hello all- I have two sheets, sheet1 and sheet2. I am condensing sheet1 (filled with approx 5000 rows to sort through) Sheet1: branch acct# name ...

http://toiletseatcoverup.blogspot.com/ - Yahoo ads not performing well? Publisher profits in the toilet? Join the best affiliate program known to man....

Hello, I'd like to write an error notice for our time sheets. I'd like to warn the user that if A124, then he needs to use A1-24 hours of leave which...