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
Pasting symbol? by Terry Pinnell[_4_]
In Excel 365 I inserted some new rows and this format symbol appeared. https://dl.dropboxusercontent.com/u/4019461/Excel365-Pasting-1.jpg What exactly should...
September 1st 16 10:14 AM
by Terry Pinnell[_4_] Go to last post
2 306
Customising date format by Terry Pinnell[_4_]
After entering a date as say 2/8/16 it's easy to format it to become Tuesday 2 Aug 2016 by using 'dddd d mmmm yyyy'. But is it possible to refine dates further...
(Multi-page thread 1 2 3)
August 31st 16 02:25 PM
by Terry Pinnell[_4_] Go to last post
28 925
Excel cuts off bottom of page in Print Preview by Lazzmatazz
In some Excel files, especially ones received via email and then edited, the Print Preview cuts off the bottom portion (a quarter or a third) of the page....
5 2,135
1 Attachment(s) formula to calculate value based on threshold by Excel Dumbo
Friends, Please see attached file and if you could please suggest a single formula that will provide the value and two separate formula that will shows...
August 24th 16 01:37 AM
by Excel Dumbo Go to last post
4 550
Automatically Maintaining Cell Values for Comparison by Sam Spade
Im importing data into Excel at various times. (Every hour) When the data initially populates the appropriate cells a formula calculates a specific...
August 23rd 16 10:32 PM
by GS[_6_] Go to last post
3 489
Formula Bar contents missing by Griffen
The contents of my worksheet cells don't show up in my formula bars. I have to use F2 to see and change the contents of my cells. The cells are not locked...
9 2,999
Highlighting cells when others are populated by Baiona
Hello all I would like to be able to use conditional formatting so that when I enter a value in a cell it highlights the first 4 cells in that row. There is...
August 17th 16 12:20 PM
by GS[_6_] Go to last post
2 322
Print titles must be contiguous and complete rows or columns by [email protected]
On Thursday, June 17, 2010 at 10:20:35 AM UTC+6, tanvnit wrote: > "Print titles must be contiguous and complete rows or columns " > > solving this error : in...
0 393
Help with charting by Excel Dumbo
Dear Friends, I am basic learner in charting. I have a file which involves multiple (more than 2) variables I would like to compare using charts Could you...
August 16th 16 02:20 AM
by Excel Dumbo Go to last post
2 457
email hyperlink - cell value in subject line by boustrophedon
I want to make an email hyperlink that includes text and a cell value in the subject line, like this: Status Change . Is there an easy way to do this or do...
(Multi-page thread 1 2)
August 9th 16 10:26 AM
by chungcu168 Go to last post
16 4,394
blank if sum is less than 0 by freds
I'm trying to get a blank (or even a 0) if the sum is 0 or less. Here's what I have in the cell SUM(D14-E14) I have answers that go negative but I'm...
6 3,507
Conditional difference between cells by jlclyde
Hello, I have a spreadsheet that I am trying to calculate the hours between two different cells based on the conditions of other cells. For instance Q:Q =...
August 6th 16 05:28 PM
by banhtrungthu58 Go to last post
2 403
Print titles must be contiguous and complete rows or columns by [email protected]
On Thursday, 17 June 2010 09:50:35 UTC+5:30, tanvnit wrote: > "Print titles must be contiguous and complete rows or columns " > > solving this error : in...
0 370
Date sensitive formulas by prattingabout
Hi Is there anyway to stop a formula from updating after a specific date without manually pasting values? Any help would be really great, thank you.
July 31st 16 08:27 PM
by LeHuonngh2 Go to last post
2 529
Edit & paste link help by Martin [_4_]
Hello, I have 16 spredsheets with people like this who are Communicants G . McCormick Mr & Mrs J. John & Grace Address Town Postcode D. McCarley Mr & Mrs...
July 31st 16 04:59 AM
by XLS S Go to last post
1 569
SUMIF alternative by Dave H
I have a spreadsheet that has 13 columns the first column for an identifier then 12 more columns one for each month. I can add a sum column but my data is...
July 31st 16 04:53 AM
by XLS S Go to last post
3 489
Crosshair is missing when I try to click & drag a cell by Maureen
All of the sudden the black crosshair went away in Excel. I still get the white cross, but when I hover in the bottom right corner to click and drag the...
July 30th 16 11:29 AM
by BùiÁnhn1 Go to last post
7 5,684
July 27th 16 08:17 AM
by Tindien3579pro Go to last post
10 3,131
vlookup last occurrence by Jack Sons
Hi all, I need a vlookup worksheet function (Excel 2K) that works with the last occurrence of the search value in the reference column in stead of the...
3 1,354
Regressions p-value is #NUM! whats wrong by ShriHanuman
I have a Data set as: Data C1 C2 C3 0.2481 1 0 0 0.9231 1 0 0 1.0361 1 0 0 0.7399 1 0 0 0.9579 1 0 0 0.8665 1 0 0 0.9891 1 0 0 0.9817 1 0 0
July 14th 16 08:01 PM
by ShriHanuman Go to last post
0 418
Post New Thread

Display Options
Showing threads 121 to 140 of 146451
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 06:50 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.