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
Percentile Analysis Across 2 Columns by BRob[_2_]
I'm wanting to calculate decile (or equivalent percentile) salaries to see if there is any difference between 2 departments (A and B). So dummy data looks...
September 4th, 2008 03:59 PM
by BRob[_2_] Go to last post
5 78
I NEED TO USE A LOOKUP FUNCT. TO RETRIEVE A PICTURE FROM A HYPERL by WERNER SLABBERT
PLEASE CAN ANY ONE HELP ME ON THIS FUNCTION OR STRING? I WANT TO CREATE A BASIC RETRIEVAL WHEN I TYPE IN A ITEM NUMBER EXCEL MUST RETURN THE DESCRIPTION AND...
September 4th, 2008 03:47 PM
by Shane Devenshire Go to last post
1 93
duplicate dates by db
In a worksheet with multiple columns of dates, how can I identify any duplicate dates , if any, among columns. many thanks -- db
September 4th, 2008 03:33 PM
by Glenn[_6_] Go to last post
2 60
Conditional averaging gives wrong result by BRob[_2_]
I've got a problem in a spreadsheet which, if I simplify down to its most basic is as follows. In the table below, the average value of column B where the...
September 4th, 2008 03:26 PM
by Glenn[_6_] Go to last post
3 74
automatically Add numbered rows in sequence from a given number by Six Sigma Blackbelt
I need to automically add rows to my worksheet. The number of rows will be derived from a number that is sum by two other numbers inputed into the sheet. The...
September 4th, 2008 03:17 PM
by Glenn[_6_] Go to last post
5 90
Problem with Copying a Simple formula by cware
I cannot believe that I can't figure this out, but... I have a SIMPLE formula in cell G5, that simply states =f5-e5 (simple difference) I'm copying...
September 4th, 2008 03:14 PM
by cware Go to last post
3 90
Compare column in 2 documents by Amiranda
I have two documents: one with a sendlist, one with a directory of names and addresses. In the sendlist I have about 1200 posts, and in the directory about...
September 4th, 2008 03:05 PM
by Amiranda Go to last post
2 97
Very easy question! (But not sure what to call it - maybe transpos by Alexander
I have the following table: A B C 1 Name Value Number 2 Alex R 1.00 20 3 Andrew R 2.00 30 4 John R 3.00 40 5 Paul R 4.00 50 5 Shaun R 5.00 60 I...
September 4th, 2008 02:37 PM
by Teethless mama Go to last post
3 101
Conditional formatting by harwookf
I have a spreadsheet with lots of formulas and conditional formatting. Currently If the cell is less than or equal to the cell above, the conditional format...
September 4th, 2008 02:30 PM
by harwookf Go to last post
1 76
Unable to highlight an unprotected cell on a protected sheet. by Del
I need to use a protected worksheet but need to use the highlight icon/button when filling in the unprotected cells, however have been unable to find a way...
September 4th, 2008 02:04 PM
by JMiller Go to last post
1 91
XIRR #NAME? error - Toolpak IS installed by Thinqer
Hi there, I've discovered a worrying problem in a large model I'm building at the moment. I've used the XIRR function in the model without issue up until...
September 4th, 2008 12:11 PM
by Thinqer Go to last post
1 83
Finding and extracting text in a cell, splitting into smaller chun by Marc T
Hi all, I've tried to do this with a combination of search and right/left, but end up with a 'too many arguments' problem once I try to build in error checks...
September 4th, 2008 12:03 PM
by Marc T Go to last post
2 83
Random help please by Terry
Hi I wish to use my ipaq (Excel mobile) for creating random numbers for a bingo game on a coach trip, instead of a cumbersome set of discs/balls etc. Numbers...
September 4th, 2008 11:35 AM
by Pete_UK Go to last post
4 67
DCOUNT Question by Alexander
Hi An easy question for someone who knows a bit about the dcount formula. I really need some help with dcount or a similar function that can do this: I...
September 4th, 2008 09:41 AM
by Alexander Go to last post
0 69
Help with Formula by Yitzhack
Hello all – Please help!!! I can’t make this work. I need a formula in cell H9 where if cell F9=WFM add 30 days to date in G9, if WFM1, WFM2, or WFM3 in...
September 4th, 2008 09:26 AM
by Pete_UK Go to last post
5 98
How to group e-mail adresess based on domain name? by DavidG
Hi, I have a spread sheet with a large number of E-mail adresses we are using for an e-mail out and i was wondering how i can group them based on the domain...
September 4th, 2008 06:01 AM
by Joerg Mochikun Go to last post
2 72
countifs Text and Dates by mokihi
Hi there I want to count how many "Level 1" cells that are older than "3/9/08". My columns and rows look like this: A B Level 1 ...
September 4th, 2008 05:30 AM
by Max Go to last post
7 52
Error dialog box meaning and how to find error by Jeanne
I have a spreadsheet that has formulas and links to another page in the spreadsheet. The other spreadsheet has a link to another workbook. On the 2nd...
September 4th, 2008 04:59 AM
by MarkFred Go to last post
2 59
Data Entry with forms by rookie
I have a data entry form that has name/address and other information for a selected producer. It is linked to several sheets with fillable forms. Each year...
September 4th, 2008 04:39 AM
by Héctor Miguel Go to last post
1 61
How to add (sum) a row cells with letter(s) aside or without numbe by JC-PS
I have a rank of C2 to N2 of which C2 to G2 will represent the days of first week of the biweekly. Between means of column G and J it represents Saturdays...
(Multi-page thread 1 2)
September 4th, 2008 04:21 AM
by Héctor Miguel Go to last post
12 191
Post New Thread


Display Options
Showing threads 20801 to 20820 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 01:59 PM.


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