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
Cutting ans Pasting cell reference problem by jrsauer
Hey...I am working with two worksheets in excel 2007. Sheet one named Data has all of my data ... each data row is like; A2-first name / B2-last name /...
August 5th, 2010 05:43 PM
by jrsauer Go to last post
0 1,713
Checkboxes overlapping text. by Frustrated Word User
Hello! I am having a hard time solving this problem. I have a spreadsheet with questions typed in the cells, then checkboxes, then a text box that when...
June 29th, 2010 07:36 PM
by Frustrated Word User Go to last post
0 1,761
Can anyone provide me the fomula ? by TQ
Hi, I need the fomula for below scenario, A4 = start date (exp.= 01.03.2007) B4 = end date (exp. = 31.05.2012) D1 = 01.04.2007 D2= 31.03.2008 E1= ...
June 6th, 2010 05:27 PM
by Don Guillett[_3_] Go to last post
1 1,367
Formula by Trainee
I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS.
June 6th, 2010 05:10 PM
by Mike H Go to last post
4 979
Excel 2010 by ComputerLady143
I have installed Excell 2010 and now when I open the program, it opening all the excels files. It also is trying to open the other files like .doc in that...
June 6th, 2010 04:47 PM
by Gord Dibben Go to last post
1 840
Copying rows of data into new worksheet but placing data into colu by Thalarctos
I have a spreadsheet which contains 3375 records (Excel 2007). My quandry is the following: I need to reformat the rows into columns for each Dealer...
June 6th, 2010 04:38 PM
by Herbert Seidenberg Go to last post
1 685
Formula ? by TQ
Hi, anyone who know the solution below ? Start Date End Date 01.01.10~31.12.10 01.01,11~31.12.11 1)01/10/09 31/01/10 ...
June 6th, 2010 04:30 PM
by TQ Go to last post
4 544
Pivot Table Formulas by AJ[_10_]
I need to create a variance formula for the data selected in a pivot table. My problem is that the data is coming in from one column and I don't know how to...
June 6th, 2010 03:17 PM
by AJ[_10_] Go to last post
0 623
Converting xls to ofx by Vance
My bank only lets me download my account data to an excel file. Does any one know if the xls file can be converted to an ofx (Money 2007) file?
June 6th, 2010 01:25 PM
by [email protected] Go to last post
8 665
No formulas Work by BG Mark
For some reason none of hte formula in a spreadsheet are working. The spreadsheet is on a netowrk and when others open it, the formulas work. When I open...
June 6th, 2010 12:58 PM
by Stan Brown Go to last post
3 508
Nested AND OR expressions by Colin Hayes
HI I need to express something in VBA , and am having trouble with it. I need to say this : IF E1 CONTAINS "1bx" OR "2bx" OR "3bx" AND J1 =11 THEN PUT 1 ,...
June 6th, 2010 12:05 PM
by Stan Brown Go to last post
7 568
Help! how to cross - data with excel?? by gloriamar
Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is blank. File...
June 6th, 2010 11:54 AM
by Tom-S[_2_] Go to last post
3 843
Split report for email by BabyMc
I have a report that contains a number of columns - and where the report contains a number of lines for a range of 'cost centres'. The report has the cost...
June 6th, 2010 11:33 AM
by Ron de Bruin Go to last post
5 637
How to determine the value? by Eric
Does anyone have any suggestions on how to determine the value within lists? For example, There is a given date in cell A1, 06-Jun without concerning year, I...
June 6th, 2010 06:17 AM
by Eric Go to last post
0 393
formula for moving information from one sheet to another sheet by Puzzled
I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be...
June 6th, 2010 05:58 AM
by FSt1 Go to last post
4 492
Find certain "Text" in a specific coloum, add corres. values by Arum Khan
Hi, I have two coloums. One has text and the other has Values. I need excel to search through a whole coloum, and summerize the results. My coloums look like...
June 6th, 2010 05:41 AM
by Ms-Exl-Learner Go to last post
2 531
how do we get 2003 .xlb toolbars and custom macros to show in 07 by bigdeal
I have custom macros that are saved in an .xls file under the XLStart/ folder in Excel 2003. These macros are referenced by an Excel11.xlb file that holds...
June 6th, 2010 01:24 AM
by Dave Peterson Go to last post
1 490
Find Function by SJT
I would like to find the second occurence of a specific alphanumeric character in a cell. For example, if cell A1 contains "BOBBY" what would be the formula...
June 5th, 2010 11:21 PM
by SJT Go to last post
5 335
Filtering or Formatting DataValidation List by Lost Cluster
In ColumnG I have the following formula array from row2 all the way down to row100 =IF(ROW(FilteredMonday)-ROW(E2)+1COUNT(F2:F100),"",...
June 5th, 2010 10:47 PM
by Lost Cluster Go to last post
6 413
Save a macro button onto a toolbar by BG Mark
I have cerated a macro button in a spreadsheet, and I would like to know if it is possible to save that button onto a toollbar so that I can use it on any...
June 5th, 2010 05:44 PM
by BG Mark Go to last post
7 455
Post New Thread

Display Options
Showing threads 21 to 40 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 05:40 AM.

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