I have a 2 sheet workbook. If cell 'sheet1 b7' has a certain word typed into it I want 'sheet2 b2' to return the value in 'sheet 1 b8'. Can I do this?...

I have an Excel 2003 workbook that has 22 worksheets. Some have smaller sets of data and some have over 1000 rows and 80 columns. The workbook does have...

PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT COMULATIVE INTREST RATE.

I would like to know how to limit a cell to only allow entry of the following number values of 1 decimal point. My limits are any value =15.0 to =100.0 as...

I have already built an extensive file using multiple pivot tables where the source data is contained within the same workbook; however, due to file size and...

Hi I have raw data with a date in the format 200701 (as extracted from DB). Does anyone know how I can conver this to Jan-07? Thanks

I have this formula. =IF(ISERROR(FIND("Relief",MasterTab!O21)),"",MAX(A$1:A1)+1) can it be modified to find three different things instead of "relief". I'd...

I have an excel document with a column of hyperlinks. I needed to extract the text of the hyperlink from that column and did successfully using this...

I am trying to utilize a SUMIF function that references a cell to provide the the criteria, so that I can changed the criteria inside a optimization...

I have created a schedule for the rest of the year, each cell being a day. I would like to plot this on our plotter as one really long continuos sheet but...

Can I copy a worksheet so that the new worksheet looks exactly like the visible portion of the old worksheet. For example, if I filter and sort, I only want...

Hi can someone tell my why this does not work please, have used this combo many times in the...

I have an invoice form in which I would like to automatically insert the price based on the item selection in another cell. My data is a small table, 2...

Hi, Below a previous posted problem not solved yet ! Maybe somebody can help ! Thanks, To explain the problem better: Have 3 workbooks with multiple sheets...

Hi, Can you pls. help me How to convert excel to HTML and use pivots in HTML? Christ

Hi, Can you pls. help How to convert excel to HTML and use pivots in HTML? Chris

Dear all I have in column A accounts. In column C i have the values. Let's say that all values should be zero. The lines are more than 15.000. I need to...

Hi, A B C D E 2000BC DEF DEF DEF 2000BC ABC 2000BC DEF 2000BC DEF 2000BC 2000BC 2000BC 2000BC 2000BC ABC 2000BC DEF DEF DEF This normally works but Im having...

I know it is possible to show zero values in a sheet by ticking "zero values" in options, but I have a situation where zero values should only be shown in...

I am working on some worksheets to keep track of activities of people in my group. They complete activities at a different rate of speed, and I want to show...