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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Up down arrow keys do not select cells if select locked cells unch by roandrob[_2_]
If I protect my work book and do not allow selection of locked cells the arrow keys and enter key do not select cells ( unlocked ) in the up down direction....
May 18th, 2009 12:48 AM
by roandrob[_2_] Go to last post
3 108
excel links by Struggling with If, Then
I have a series of workbooks linked by multiple "If, Then, Else" equations - 50 per cell, approximately 200 cells per workbook. When I try to send the...
May 17th, 2009 11:43 PM
by art Go to last post
1 140
calculation-iterations by widman
Is there any way to set 1 worksheet for iterations so that it doesn't return the circular reference, but leave other sheets working normally?
May 17th, 2009 11:42 PM
by art Go to last post
5 153
Can i get a formula to change hours into currency £ by David Wilson[_2_]
I am looking for a formula to change working hours i.e (78h 30m ) into currency i.e £6.00 £6.00 x 78:30 ( h:mm ) = £471.00 Excel 2007
May 17th, 2009 11:34 PM
by FSt1 Go to last post
2 223
Using excel to integrate journal entries into Great Plains by joeyg
I have 20 companies which I want to use excel to upload journal entries via Integration Manager into Great Plains. I've built the csv files and the...
May 17th, 2009 11:20 PM
by joeyg Go to last post
0 259
Plotting calculated point by Bradley Steve
My data 781 249.77 781 449.72 766 649.93 761 849.49 723 1049.39 719 1249.65 692 1449.54 672 1649.80 644 1849.70
May 17th, 2009 10:17 PM
by Bradley Steve[_2_] Go to last post
4 243
counting matching multiple entries by colensa
I have two columns containing numbers. I want to count the frequency with which the two columns' numbers match i.e. the number of times 5,9 or 6,8 or 13,21...
May 17th, 2009 09:11 PM
by Bernd P Go to last post
2 206
How to reference variable range? by WhatsUp31415
I have one column of data (B9:B721) and a parallel column of tags (C9:C721). The data are arranged with all of "Tag1" data, followed by all of "Tag2" data,...
May 17th, 2009 07:20 PM
by T. Valko Go to last post
4 196
combine cells with different formats by Truong
I want to combine the contents of 3 cells that have different formats (e.g. cell 1= normal text, cell 2=italics text, cell 3= normal text) so that I have a...
May 17th, 2009 06:21 PM
by FSt1 Go to last post
2 215
Dragged 2 columns closer together, now can't see columns in betwee by Carebeatle
Please help! I wanted to look at column "C" and column "F" right next to each other, so I dragged the edge of column "F" over to the edge of column "C". But...
May 17th, 2009 06:10 PM
by David Biddulph Go to last post
2 202
Display zero is no data is found by wcurtis
I have an IF formula that displays a zero if the number falls between a set of numbers. =IF(B30450,B30-450,IF(B30426,B30-426,"0")) But if no data is found...
May 17th, 2009 03:51 PM
by Sheeloo Go to last post
3 194
Employee login time sheet by widman
Does anyone know of a simple excel based time sheet where 5 employees can log-in and out (morning and afternoon) with passwords and excel could mark the...
May 17th, 2009 03:10 PM
by widman Go to last post
2 201
Text Box in Excel for noddy users! by Anita
I've created a 'form' in Excel (not using the form controls though) - and protected the sheet so that only certain cells can be edited. However, I have to...
May 17th, 2009 03:08 PM
by Anita Go to last post
5 217
A1 and B1 by Omar
Dear all, I have two cells A1 and B1. B1 takes from A1 If A1$B!b(B zero, I want the real digit in A1 to be presented in B1, but if A1=zero, then I need to...
May 17th, 2009 02:50 PM
by Teethless mama Go to last post
3 205
Concatenation by M Thompson
Hi I need to join the numbers from 2 cells so that I can use them in a vlookup. When I do a concatenation, then a paste special, values, the vlookup can't...
May 17th, 2009 11:16 AM
by Max Go to last post
5 245
Weard problem with formatting of charts in Excel 2007 by Rolando
One workbook with 5 sheets with each different charts, Excel 2007, Wind XP. One of the 5 charts is not shown when the workbook is opened unless a preview is...
May 17th, 2009 10:08 AM
by Rolando Go to last post
7 218
Why does this work? by M Thompson
I got this formula from Max, Singapo =VLOOKUP((A1&B1)+0,Sheet2!A1:C6,3,0) I would like to know how the +0 is working in this. I've spent about alot of...
May 17th, 2009 05:33 AM
by M Thompson Go to last post
4 184
copy & paste values+formats from excel to word by rockhammer
What is the best way to copy the values & formats of a table in excel into a table in word? I've tried various ways but it doesn't seem to work quite the way...
May 17th, 2009 02:29 AM
by rockhammer Go to last post
2 217
Sorting data but not the first row by JRD
Can someone tell me how to sort data say in alphabetical order without moving the top row? I am using Excel 2003. Thanks John
May 16th, 2009 10:47 PM
by Ken Wright Go to last post
1 201
Random Numbers by robert morris
I need help with a VBA for creating NON-REPEATING random numbers between 0-9 in Col B4:B13 and Row C3:L3 Bob
(Multi-page thread 1 2)
May 16th, 2009 09:55 PM
by Jack Sons Go to last post
14 306
Post New Thread


Display Options
Showing threads 20001 to 20020 of 139764
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 02:44 AM.


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