A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
sort 2 column in the same time "" as dictionary "" by Mahmoud Mustafa
Hello all I need to make sort of pages to be like a dictionary is that possible I put a test file on the next...
May 1st, 2010 01:53 PM
by Mahmoud Mustafa Go to last post
0 84
Nested formular to give a word answer based on 2 cells by Sean
I have a s/s which I want to produce a statement based on 2 cells G170 is a cell that contails a sum (if cells above are filled it it will add them up) I170...
May 1st, 2010 08:46 AM
by Sean Go to last post
4 123
how do i use format cells to alpha / numeric values by Samvid69
HAVE A STRING OF DATA i WANT TO ENTER into a cell, but I also want to set format to set the values. eg. if I put in asd123 I want it to appear as ASD123 but...
May 1st, 2010 07:41 AM
by ozgrid.com Go to last post
2 96
Maximum number of cells for 'SUM' ? by Groybs
I have a spreadsheet with 56,314 rows of text labels. I have a formula in each row off to the right of each text label. The formula tests for a specific...
May 1st, 2010 04:25 AM
by ozgrid.com Go to last post
7 89
Copy formula from one worksheet to another to get value in 2nd wks by JR
Hi, I have several worksheets where I have totaled certain columns. I want to take that total and copy it onto a summary worksheet (not adding these formulas...
May 1st, 2010 03:47 AM
by Groybs Go to last post
2 78
Conditional Formatting on Index,Match formula by Nadine
I am using Excel 2003. I am trying to use Conditional Format for a cell that contains the following Index, Match formula:...
May 1st, 2010 03:12 AM
by T. Valko Go to last post
3 122
Conditional formatting problem by Coco212
I KNOW I am being incompetent but must humbly plead for help: cell p3 has the number 412 in it cell t3 has the number 470 in it I want p3 to be highlighted in...
May 1st, 2010 01:03 AM
by samrah Go to last post
3 91
Logical Test for blank and then for score by Mikesnhu
I am trying to score results - M4 = test criteria (e.g. 5) - O4 = test result (blank or a number .001 to 9999) - P4 = scoring (if the result is blank, retun a...
May 1st, 2010 12:02 AM
by PatM Go to last post
1 104
extracting data from one cell to another by pat67
I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there...
April 30th, 2010 11:50 PM
by Bob Phillips[_3_] Go to last post
8 122
summary values across worksheets within the same workbook by Gordon
I have a single workbook consisting of 53 sheets (one per week in the fiscal year). I have a summary sheet that I need to extract data from the same cell in...
April 30th, 2010 11:40 PM
by Ormond Go to last post
2 111
Count Multiple Text Entries by Craig
Hi, Following a post I did yesterday 'Count Text to get a Percentage'....my next post is that I need to count text entries in differing cells to get a result...
April 30th, 2010 11:36 PM
by ker_01 Go to last post
1 92
Drop list and redirect by WT
I have two workbooks W1 and W2, they both contain the same columns with the same type of data. I know how to have W2 display the changed cell when W1 is ...
April 30th, 2010 11:11 PM
by L. Howard Kittle Go to last post
1 72
Sharing workbook by Olivier
When i try to start sharing a workbook i get immediately the message: "The file is no longer shared". The file cant be saved anymore and so sharing is...
April 30th, 2010 10:17 PM
by Gord Dibben Go to last post
3 138
YES or NO formulas by Alyssa
Hi, I have a column that has a series of numbers it will always be either 10000 or 10100 , I want it to return a No for 10000 or Yes for 10100 in the field...
April 30th, 2010 10:16 PM
by FSt1 Go to last post
3 84
Sumif Function by worduser
I successfully wrote a formula to give me the sum of one column (F) based on whether or not column D has an "x" in it. It works fine in one spreadsheet, but...
April 30th, 2010 10:02 PM
by Lars-Åke Aspelin[_4_] Go to last post
1 144
determine a range using a formula by Jonathon Shull
I have a spreadsheet with budgeted financial data in columns, the heading for each column is a 3 letter monthly abbreviation. Each month actual financial...
April 30th, 2010 05:23 PM
by Jonathon Shull Go to last post
2 95
Need some help with auto-fill by Per Carlsson
Im trying to get autofill to fill dates in batches of ten after each other, but with little success. like so... Is there anyone who can help me with...
April 30th, 2010 05:02 PM
by Pete_UK Go to last post
1 74
VBA to autofill from relative location by AlexJarvis
If I need to autofill column B from the last cell that has data in it to the same row as the last cell of column A that has data in it, how do I set the...
April 30th, 2010 04:47 PM
by AlexJarvis Go to last post
2 108
Finding most recent date for each customer - XL 2007 by Geoff B
I have a simple list, the left column is the customer number, the right column is the date of every sale made to the customer. I need to filter this list to...
April 30th, 2010 04:42 PM
by Herbert Seidenberg Go to last post
2 109
SAMPLE EXCEL DATA by EricB
How do I sample data in a EXCEL spreadsheet? Say I have 50.000 records and I want to sample say 0.1% or 50, what function do I use?
April 30th, 2010 03:44 PM
by Jacob Skaria Go to last post
2 68
Post New Thread


Display Options
Showing threads 841 to 860 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright ©2004-2018 OfficeFrustration.
The comments are property of their posters.