A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
CONCATENATE - #VALUE! error sometimes ???? by [email protected]
I have a multi sheeted workbook, currently in EXCEL 2003. On each sheet of the workbook, in cell A2 I have CZ in cell A3 I have 23 in cell A1 I have...
2 1,017
Excel INDIRECT or CONCATENATE ? by [email protected]
I am struggling with either INDIRECT or CONCATENATE in (Excel 2003 or 2007 I have access to either). Using a multi sheet workbook, every month I have to go...
April 16th 15 10:52 PM
by simnamsinh Go to last post
1 661
Returning contents of a cell identified by two logic tests by SteveRH
The attached spreadsheet extract (please excuse the format, and why can't I upload the spreadsheet?!?)is a much smaller version of a live problem I can't fix...
April 15th 15 02:20 PM
by Claus Busch Go to last post
3 662
Conditional formatting on dynamic named range by Håkan Björkström
Hello I have an Excel 2007 sheet with a dynamic named range, "WholeMain", to which I apply some conditional formatting. When I apply a formatting to range...
April 15th 15 10:15 AM
by Håkan Björkström Go to last post
2 565
offset formula causing Circular reference by Fighting Illini Mike
I have come across this before but don't know what the solution is. I had a Excel 2010 workbook open with many offset formulas in it when I opened an old .xls...
3 956
SUMIFS ? for multiple ranges by L. Howard
The formula to sum "C" in these four tables escapes me, if it is even possible. My SUMIF, SUMIFS & SUMPRODUCT search comes up with no "four-way"...
April 10th 15 07:47 PM
by L. Howard Go to last post
4 721
How to change the direction of the enter key to go horizontal by BManske
I recall when entering data in an excel chart, that I could change the direction from vertical to horizontal when using the "enter" key.....and can't...
5 3,763
WORK HOURS DIFFERENCE BETWEEN TWO DATES by CHRISTI
I need to calculate the total WORK-hours (08:00-17:00) between two date/time-stamps; -excluding WEEKENDS -excluding PUBLIC HOLIDAYS eg#1.: A1=START DATE/TIME...
(Multi-page thread 1 2)
13 3,026
How can I pull certain row info based on column info by Netti
I would like to create a worksheet that looks up data in column 1 and then pulls specific cell data from that row. This is not my spreadsheet and it's huge,...
1 481
Save Random Number by Paul B.
I would like to generate a row of 5000 - unique random numbers and not have them change once generated. Any ideas would be appreciated. Cheers
April 3rd 15 03:50 AM
by jester23423 Go to last post
5 2,295
Excel 2013 problems as listed below. by Desai Sanket
Dear all, please help me on below matter. This spreadsheet contains two Work Sheets "Foundry" and "for example" Foundry worksheet contains 3 columns: Serial...
1 510
Calculating my work hours minus lunch break and then adding forweekly total by [email protected]
I'm having trouble creating a time worksheet. I want to subtract my start time from my end time, determine if I have worked longer than 4 hours (company...
March 28th 15 06:36 PM
by Alfred Heiligenbrunner Go to last post
2 921
Excel named tables or dynimac named ranges? by Håkan Björkström
I have Excel projects using a lot of small lookup ranges - also large worksheets. I have a question about advantages/disadvantages of named tables and dynamic...
March 26th 15 07:49 PM
by Håkan Björkström Go to last post
0 542
automatically putting in dates like tuesday/thursday by [email protected]
Myrna, Thank you!!! Your formula worked perfectly for what I needed, using Sheet1's cell B1 as the start date. However, I am now trying to exclude specific...
0 494
Help With Min/Max Values by tb
I am trying to set up an Excel spreadsheet that will help me create bills of material. The problem that I have is that one of the part numbers in the...
March 24th 15 09:30 PM
by Claus Busch Go to last post
1 546
Conditional formatting by Håkan Björkström
I have a large sheet with dates in column A in ascending order. There can be multiple rows with same date. I need to conditional format (mark) the row...
March 24th 15 01:57 PM
by Håkan Björkström Go to last post
1 447
Counting specific number following decimal point in a row by [email protected]
Hi Everyone, I have the following dataset 150.1 153.2 154.3 155.1 155.1 157.1 157.4 I would like to count how many cells have 0.1 given the condition that...
March 24th 15 07:31 AM
by Claus Busch Go to last post
2 516
Can Excel automatically insert current date in a cell? by AdrianXing
Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up?
(Multi-page thread 1 2 3)
24 9,227
1 Attachment(s) Extract parts of cells to new columns by shani1975
Hi, hope you all can help me. I am stumped. I have a spreadsheet with info in Column A that is directly dumped from another program. I need total time for each...
March 19th 15 08:20 PM
by Claus Busch Go to last post
1 515
Adding up to a whole number by Aaron R
Hi there The title may be misleading than what I actually want doing so for this I apologise. What I basically need doing is excel to work out half of 1...
March 18th 15 01:54 PM
by Claus Busch Go to last post
1 480
Post New Thread


Display Options
Showing threads 201 to 220 of 88499
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 On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:47 AM.


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