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 Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Values from a weighted average by JK123
Hi all, I am new to the forum so hopefully this is posted in the correct place. I am trying to three derive values from a weighted average that I know. The...
November 30th 15 01:11 AM
by zvkmpw Go to last post
1 552
Expand/Collapse Grouped Data in Protected Worksheet by Robert Slattery
I've created a worksheet that will be distributed to 300+ users in an investment group. It contains formulas and computations in cells that could easily be...
November 24th 15 06:08 PM
by GS[_6_] Go to last post
8 4,825
Convert seconds to hh:mm:ss? by Terry Pinnell[_4_]
Is it possible with a single formula to convert a number of seconds sssss to the text hh:mm:ss please? For example, 6185 would become 01:43:05. -- Terry,...
November 23rd 15 03:17 PM
by Frozen Go to last post
5 598
Need Help with ROUNDUP by [email protected]
I need to combine a formula and ROUNDUP to arrive at the next whole number value of a formula and do not want to burn a cell calculating the value of the...
November 22nd 15 06:19 AM
by pedro Go to last post
5 657
Formula in Col B to detect if an entry in a list in Col A is uniqueor not by [email protected]
I have a two column spreadsheet. It has thousands of rows. Col A contains a text entry in each row from row 2 onwards (row 1 being the header). I want Col B...
2 459
Export a text file from each row of a spreadsheet by Greshter
Hi, I'm sure this has been done before and is in other threads but I thought I'd ask. I have a series of rows that I need to export as individual text files...
November 16th 15 07:21 PM
by GS[_6_] Go to last post
2 433
Dynamic Hyperlinks by [email protected]
I have a workbook with 40 some sheets. 1 is a summary sheet and the others are the detail. Some detail sheets have more than one piece of information. Each...
November 14th 15 07:19 PM
by Claus Busch Go to last post
3 507
Office 365 Home Premium Excel vba options greyed out on developer tab by michaelberrier
I use Excel as part of Office 365 Home Premium, and recently I had a workbook I've been using for a while with macros open with the message "We found a problem...
November 14th 15 04:20 PM
by michaelberrier Go to last post
0 418
How do I suppress a zero value or #VALUE! for a Pivot calculated i by DJL
I have entered the following formula within a new calculated item to calculate the variance between actual and budget values with the view to making zero...
(Multi-page thread 1 2)
10 866
Vlookup is giving #N/A by [email protected]
I have this formula in a spreadsheet and it's bring back the correct items needed. However, if there is nothing to bring back, I'm getting #N/A. I need it to...
November 10th 15 05:20 PM
by Claus Busch Go to last post
1 348
How to restore BKF files ? by brucepeters
Backup files of the system and other significant data even may get corrupt or become inaccessible. However, you taken care to keep the BKF file secure, but...
6 1,521
How To Search And Replace A Special Character In A String by tb
I have some part numbers in string format that include the caret (^) symbol. For instance: ^^^235-741-22 STAINLESS STEEL NUT I would like to get rid of the...
November 4th 15 08:48 PM
by Claus Busch Go to last post
3 442
invalid cell reference by schugh
I am getting a #REF! returned when my data table changes size.................I have a table being brought into a spreadsheet via an external source, this...
November 3rd 15 12:25 PM
by schugh Go to last post
0 379
wrap text function causes data to disappear in cell (visually only by DaveT
When I use the wrap text option for a cell, the data in the cell is no longer viewable when I move to another cell but is clearly still there when the cell is...
(Multi-page thread 1 2)
16 1,429
Excel 2013 by frescoabeyta
Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: "Excel 2013 has stopped working". I looked around and found a...
October 30th 15 03:44 PM
by cristianrenta Go to last post
1 636
Weird Problem With Excel 2013 by tb
I am using Excel 2013, 32-bit, on a Windows 7 PC. I have this Excel spreadsheet where every now and then one or more of the rows are automatically reduced to...
October 19th 15 10:34 PM
by tb Go to last post
0 527
Copying a worksheet - won't work help please by [email protected]
On Monday, March 6, 2000 at 3:00:00 AM UTC-5, Chrissy R wrote: > It sounds as though the workbook and/or the worksheet are > corrupt so the best option may be...
October 16th 15 12:07 AM
by GS[_6_] Go to last post
1 519
Can't Break Links by [email protected]
On Tuesday, December 7, 2010 at 8:38:07 AM UTC-8, Dave Orth wrote: > I had the dreaded "This workbook contains links to other data sources" but was completely...
0 577
2 Attachment(s) Excel Vlookup Not Returning Correct Information by smim
Vlookup formula =VLOOKUP(A3,DATA2!A1:B19,1,0) does not return correct information. I am searching for a numeric code from sheet one in sheet 2 to display a...
October 11th 15 07:58 AM
by Claus Busch Go to last post
1 668
Help with Excel Formula (Multiple Vlookups in an If Statement" by [email protected]
I have a table with the top row headers (classifications) of "LOW," "MIDDLE," "MODERATE," "UPPER," & "UNKNOWN." Under each are random (identification) numbers...
October 9th 15 05:50 PM
by Claus Busch Go to last post
2 592
Post New Thread

Display Options
Showing threads 201 to 220 of 146428
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 02:07 PM.

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