I'm not even sure if this is possible, but if anyone has advice I would greatly appreciate it. I'm transcribing information from my study into an Excel...

when i type entry, nothing appears in box on spreadsheet.. also the tool bar is gray & most wont work

Hi, I'm trying to do some data analysis using Cochran's test for outlying variances. I have 4 replicate numbers from each of 20 laboratories. I calculate the...

I am merging data from an Excel chart into a Word document to create a phone directory for our church. I've done merges many, many times before...

Hi - I;ve had a look through and cant find a solution to this problem. I have a column that returns a Quarter (of financial year) dependent on the date of an...

While working on a sales rep sheet I noticed that when you filter a table in your chart some of your functions are not recognized even though you’re still...

I have 3 workbooks, payments payroll and receipts which are linked by formulas. I want to use them as master copies and use them each year. However when I try...

Hi My data set, has located on column x, for example: (x2:x570),i want to move this column to desired row number (x7644). I need to a macro or function, when...

Dear Expert, I have a question about conditional sum to calculate moving average. 21-Mar 22-Mar 23-Mar 24-Mar 25-Mar 26-Mar Stock...

If a cell has text and numeric (date) is there a way to pull the date out easily ? E.g. Product dropped off on 11/01/2009 by Michelle Smith I would like to...

I see that you have a VBA solution from Roger, and that this works for you. However, here is a modified formula solution. With your data in column A and your...

HOW CAN I USE "MODE" ON WORDS (NAMES OF PEOPLE)?

i have delivery/collection spreadsheet and i'm trying to set some sort of worning to tell me that a collection is over 30mins late any tips

This is really making me crazy. I have data that I have downloaded from mysql. The problem I am having is that every cell is defaulting to text format with...

When combining text and cell values in a concatenate function, I would like to control the number format in the concatenate cell: comma separator, decimal...

I have a function that alphabetizes an array of text: =INDEX($A$1:$A$10,MATCH(ROW(A1),COUNTIF($A$1:$A$10,"="&$A$1:$A$10),)) CSE-entered I also have a...

It's hard to describe what I am doing, but here's my...

Sorry about the title, let me explain in more detail: In row A, I have various listings. The title is always in caps, the user is always in mixed case. For...

Hello, I want to use a VLOOKUP to pull information out of a chart depending on what colour the cell has been filled in. The Look_Up value needs to...

A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0...