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
Function to add name of Sheet to a Column? by msnyc07
I am preparing to merge sheets in a workbook, before I do I need to find a way to pull the sheet name into ColumnX so once merged I will retain the...
May 25th, 2010 10:46 PM
by Brad Go to last post
4 218
RANDBETWEEN generating numbers outside range by Penny Black
Using Excel 2003. Simple task of trying to generate a pseudo-random number between 1 and 52 (yes, a deck of cards). I'm populating the cells with...
May 25th, 2010 10:14 PM
by Mike Middleton[_2_] Go to last post
5 229
linking a sales receipt worksheet to an inventory worksheet by Tator Bug
I have a sales receipt worksheet that has all my sales items on it. I also have an inventory worksheet. I would like when I make a sale that it automatically...
May 25th, 2010 09:11 PM
by Tator Bug Go to last post
0 155
Changing dates across multiple worksheets by Malcolm
I have a workbook that contains 18 sheets. Is it possible to change the date on sheet 1 and have it change on the other 17 sheets, even though the sheets...
May 25th, 2010 08:59 PM
by Gord Dibben Go to last post
5 227
returning a text value by Tim
I think this is simple but I am confused with it. I am creating a softball roster. Column a is the positions, Column b is player for inning 1. C is inning 2...
May 25th, 2010 08:23 PM
by Fred Smith[_4_] Go to last post
1 153
To keep in just one cell all values related to a monthly rate by Dalcin
I have to update in a monthly basis a currency rate. I know that there is a function, formula (or something like that) to link a month descripton to a...
May 25th, 2010 07:48 PM
by Gord Dibben Go to last post
3 136
how do i insert todays date in a spread sheet just prior to print by wayne h
wish to have excel automatically add date to same cell in spread sheet every time it is opened.
May 25th, 2010 07:15 PM
by Gord Dibben Go to last post
2 202
Replace a field with value from the next row by Krish
I have a table listed with columns Product Unit Of Measure Cost % Markup I have products number repeated twice one for unit of Measure "CS" and another for...
May 25th, 2010 07:14 PM
by Krish Go to last post
0 171
Multiple sheet references in one function by Alex
=SUM(--('Sheet1'!$B$2:$B$2000=BB$3),--('Sheet1'!$B$2:$B$2000=BB$2),--('Sheet1'!$D$2:$D$2000=$B7),...
May 25th, 2010 06:18 PM
by Alex Go to last post
0 183
formula to look up ref in one sheet and offset in another by vickya
Hi there I am trying to create a formula which will use a product code typed into a cell in the same sheet, look up this code in a separate file, and give me...
May 25th, 2010 05:59 PM
by Dave Peterson Go to last post
1 231
Sumproduct is returning irregular values by Marlaine
Hi there I am developing a skookum s/s where I am returning values based on various criteria and am using sumproduct. The issue seems to be with the format...
(Multi-page thread 1 2)
May 25th, 2010 04:48 PM
by Marlaine Go to last post
11 265
Combine rows to print on one label by Clearcreek
School Pupil ID LastName FirstName Grade Course/Grade Clear Creek 210310 Archer Heath 5 MUSIC S Clear Creek 210310 Archer Heath 5 SOC...
May 25th, 2010 04:27 PM
by Clearcreek Go to last post
0 195
Automate a Solver solution by Janet
I need to calculate a value to minimize a formula - I can do this with Solver. The problem: I have 400 rows for which I have to use the Solver calculation -...
May 25th, 2010 03:40 PM
by Janet Go to last post
8 294
Group or ungroup in a shared excel workbook by Tracey
Hello, Could you please let me know if its possible to be able to group or ungroup (groupings already set up) while an excel workbook is protected and...
May 25th, 2010 02:34 PM
by Tracey Go to last post
0 203
Calculate difference between current date & prior by S
I am looking for a formula that would calculate the difference in dates but display in weeks-can this even be done? Col A Date Received 4/15/2010 Col...
May 25th, 2010 02:14 PM
by S Go to last post
3 144
Search for a particular letter in the sentence and print by ks1
excel has to search for a paticular letter in a row and print the preeciding word in the next cell
May 25th, 2010 12:06 PM
by Jacob Skaria Go to last post
4 144
Embedded lookup by HotaG
Can a lookup be embedded in another lookup? A file has separate sheets for each month with identical formats. A file has 13 sheets, one for each month and a...
May 25th, 2010 10:50 AM
by Steve Dunn Go to last post
3 148
change color font after updated by reza
hi all, i work with excel everyday, sometimes i forget which one i already changed in that sheet. i.e in column D, i have a values. now every time i changes...
May 25th, 2010 07:50 AM
by reza Go to last post
3 221
How do I change the pge size to A4 in excel 2003 by Peachz
Hi I'm not too good at this, when I print the worksheet its not in A4 size. How can I change it to A4. Any help would be great thanks
May 25th, 2010 07:48 AM
by Jacob Skaria Go to last post
1 268
120= rupees one hundred twenty only by digit to text
i just want to know the formula which translate digit to text for example if 120 written in any cell and other cell we want result "rupees one hundred twenty...
May 25th, 2010 06:46 AM
by bala_vb[_27_] Go to last post
2 189
Post New Thread


Display Options
Showing threads 321 to 340 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 05:12 PM.


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