I am using dglinfo with if statements, and I know that the spreadsheet is updated but the only way I can show the value in particular cell is by hitting the fx. Is their a way to show all the values at once instead of going cell by cell?
View 2 RepliesWhen I update a cell (change A1 from 2 to 3), any cell that references that cell correctly changes its value (B1 = 2*A1). However, the screen will show the new value in B1 (6) over the previous value (4). At first I thought it almost looked like a strike-through, but then I realized the old value and new value were simply stacked in B1.
If I scroll the screen away that cell and go back to it, the correct value will now show without the stacked values. I'm not having this issue in any other program (Open Office), and I don't seem to be having any kind of stacking issue in any other Microsoft program.
I have to compile spreadsheets as tables of various values. One column in particular is a column of ID numbers and the worksheet is very very long. I need a method for checking this one column for duplicate ID numbers.
View 4 Replies View RelatedI have a spreadsheet with a lot of rows and there are three columns that can have a one of two values in it. These values are constantly changing from row to row, not just like a yes or no sort of thing. However 80% of the time they are the same values in all 3 columns, but I want some way of quickly identifying when there is a difference between column G, I, & K which are my three column names. So is there a way of conditionally formatting this to make a difference highlight in red or something like that?
View 9 Replies View RelatedDid you try filtering the list see Debra Dalgleish's index page
[url]
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: [url]
Search Page: [url]
"BorisS" <BorisS@discussions.microsoft.com> wrote in message news:1DD652B0-CDC0-43D4-9D46-7A3616FF7255@microsoft.com...
> I am getting lots of values in my table which are zero. I have a calculated
> item, and don't know if that is the problem. How, if at all, can I get any
> line which has all zeros to not show up? the table gets excessively long
> with them, not to mention the calculation takes forever.
>
> --
I'm making a chart for values of L6:L40 which are all percentages.
The chart is a bar graph..
On C6:C40 i have movie titles. (the amount which vary by week.
ON MY CHART.. i always have at the bottom a bunch of bars that just show 0.00%
How can i get the bar graph to only recognize values either where..
values are greater than zero in the l column rows.. or value is not equal to "" null in the c column?
Is this possible?
I made a chart to show performance above and below average for sales teams.
When team is selected with no salesperson, value should be 0.
Employee selected and will show there week by week trends above or below. Seemed like a good idea.But the zeros (team level) are being displayed as plus or minus bars which isn't right and the labels show "0".
I find the pivot table is actually showing strange values if you click in the cell even though it displays a 0.Notations positive or negative like 3.80647894157197E-16.
The underlying data is an average formula and selecting invidual criteria, I show there are no anomalies.
I Spoke too soon here, I am getting value errors, how to do it with conditional formating. I tried if cell value is =to #DIV/0! then white (dosent work). Richard this dosent seem to work mate =IF(SUM(F6:V6),"",AL6/SUM(F6:V6))
View 9 Replies View RelatedI have the Range B:F for "Values MJ" and columns G:K with "Values RT". In column A there is a letter for each row but some letters could appear more than once and I want to have only unique letters in column A and merged the Range B:F for "Values MJ" and columns G:K with "Values RT" in the same row for those repeated letters.
Original data:
A
B
C
D
E
F
G
H
I
J
[Code]...
If a letter only have values in range B:F print "Missing" in range G:K for the same row. If a letter only have values in range G:K print "Missing" in range B:F for the same row.
I'd like to delete the row of the letter if the repeated letter has values in B:F, since letters for ranges B:F always appear after the letters that have values in range G:K and since I'd like the output in same sheet.
Output desired:
A
B
C
D
E
F
[Code]...
I have excel 2010....
I am having problems creating a chart off of the following data. Each of the cells which have a numerical value are v-lookuping from another sheet. It needs to remain this way as when I switch brands (through data validation), the numbers will update and the chart should as well. Right now, the chart shows these values as zero. I have done this a million times in excel 2007, but now with 2010, I keep having this problem
2010/Jul
2010/Aug
2010/Sep
[Code].....
I want cell B4 on sheet 3, to show the value of cell B4 on sheet one ... only if there is a value in B4 on sheet one then i want the rest of row 4 to be copied to sheet 3 also.
HOWEVER if the value in cell B4 sheet 1 is BLANK/EMPTY then i want the full row to be over looked and the next row to be checked (B5 all the way to B30)
Once B4-30 on Sheet 1 has been checked and only the rows showing a data/value have been copied to sheet 3, i then want the same process to start again on sheet 2 - Again only the rows showing data/values to be copied.
I'm trying to do a line chart showing two teams and their cumulative scores over the period of a game. I've attached a sample with mock data. Is it possible to change the x-series of the charts to display custom time intervals like 0 min 1 min, 2 min, 3 min, 4 min, etc? Currently the x-series only has labels for each specific time there was a change in value. I've tried to change the scale but the options that I want aren't there.
View 2 Replies View RelatedI'm trying to place a pivot table in an existing sheet in order to have a list of names next to a P&L. I've got several criteria to filter the names, but when I apply the filters to the pivot table, not all the people show up. The weird thing is that the total at the bottom of the pivot table, which is a simple sum of time in a given month per person, calculates the correct number as if all the employees are there.
When I do the same table in a fresh sheet, in the same file, it shows correctly. It's only when I try to put the table in an existing sheet that it abbreviates the list.
I would like to be able to enter the data into the grey cells and then have the yellow cells auto generate a result. The only problem is that the required value in cell B5 is from when the entered value in B4 is looked up in the table, rounded UP to the next highest value and then the answer from the next cell.
So, if I enter in B4 a value of 500, a lookup is made in the table and the next highest value would be 553 with the correct answer shown in B5 being 13.
I am entering text into a cell and as soon as I go over 241 chars, give or take, the data turns to a row of ####'s when I get out of the cell. Help says the limit is 32K and I have wrap text on. What am I missing? The data displays OK when the cell is current, but goes away when the cell is not . When I preview a print I have the ####'s. I am using Excel 2000.
A1 has the value 7
I want the code to take that value and add a leading 0 and put the result as 07 in B1.
I created a formula in a cell and it worked fine but then I created the same formula in the cell just below it and I changed some of the numbers and when I hit the enter button the formula showed up in the cell and not the final result which would be the answer to the formula. Does anyone know why it would do this? I have an example below....
View 6 Replies View RelatedI have a formula in a cell and when I use the formula bar it shows me the correct answer but it doesn't show me it in the worksheet. Only the formula shows up.
The same formula could be another place in my worksheet and work fine.
I have tried changing format. Copying formula from another location and changing the information to fit my needs it won't show me the result.
The following concatenate function was working, then mysteriously stopped. When working it returned the data that I requested, now if I click on any concatenated cell and hit enter I get the function string, see below.
='Input DATA'!C2&" "&'Input DATA'!B2&" "&'Input DATA'!F2
InputData is my tab that is being referenced. All other functions/formulas are working as designed. The data in the referenced cells is still there and I changed from text to number to general, etc but I still get the same result.
I have a cell that has a formula in it and is also Excel Dates & Times coded. Hence when the repsective cells are empty and there is no values to be calculated the date "00-jan-00" shows. how to prevent this from showing up allowing for a blank cell to only show?
View 4 Replies View Relatedone cell gives me the MAX value of a range of cells
I want to then use that value to refer back to the range of cells and return the value one column to the left
This formula returns "A4" which is the cell number for this result I want to show but it just enters A4 not the contents of cell A4
="A"&(MATCH(B10,B2:B5,1)+1)
i have set of data excel with the below ;
date---------------cost
01/02/2014---------5
25/02/2014---------10
09/02/2014---------1
10/02/2014---------8
06/03/2014---------9
20/03/2014---------25
etc...
how do sum with selected cell criteria by month (likes drop down list) , e.g.
sum of February, or sum of March, etc...
with helper column, if i selected month of February, showing data sum February or if i selected month of March, showing sum data March...
In a particular CSV Excel file I want to populate "Description" column with a HTML template Code by merging 3 columns of HTML. The HTML has almost 20,000 characters. Now before merging and after merging when I copy paste the HTML in any cell it doesn't show all the code that I have copied. and when I merge all the 3 columns. a lot of HTML data seems to be missing. I think excel has some sort of limit and it is not allowing all these 20,000 characters merged and combined in 1 cell. I am stuck at this point and can't upload the CSV as the HTML is missing a lot of coding.
View 2 Replies View RelatedI tried doing Ctrl + ~, but it did not work
View 14 Replies View RelatedI want a cell to be blank if the sum is Zero. I am getting a divided by zero error, I tried this formula: =IF(SUM(C6/D6)=0,"",SUM(C6/D6))
View 4 Replies View RelatedI've got an array of data about 30x1500 cells in size, I want to use this data in a table I'm making on another worksheet.
Normally I'd just use VLOOKUP and this works great in most cases but I want to do something a little bit more complicated. Basically I want to (in normal English) have excel look at the table, find a cell that matches criteria in this data array, then compare to another cell on the same row in this array. If the criteria for these two match then display the data from another cell on the same row. The criteria for matching the first cells would be an exact value, both being strings of text.
I've tried using a couple of nested VLOOKUP and IF statements but failed .....
if there's any sort of script which allows the file's last modified date to be shown in a worksheet?
View 5 Replies View RelatedI have a formula when C15 is empty it shows -18 value. I need if the value is blank then show blank?
Code:
=IF((Data!C15-32)*5/9="","",(Data!C15-32)*5/9)
I was given this Formula to use in a cell to calculate the total hours from 2 different cells, from inputting date and time from and to dates..as an example from 4/1/14 0:00 thru 4/1/14 12:00.....The problem I am encountering is that when the spreadsheet is 1st opened "+1" is visible in the cell where this formula is. I am asking how the formula can be altered to have the "+1" not visible in the cell before any date and time is entered.
= INT(F13-D13)*24+(((F13-D13)-INT(F13-D13))/0.04166666)+1
When i put a "0" in a currency formatted cell, the result is a blank cell. If i put any other number in there other than "0" it shows a dollar amount of that value (even .00001 works). I have also noticed that before i put a zero in that cell, i can go to the format of that cell, select currency, and i see a sample in the sample box ($0.00). But if i go to that cell, put a "0" in it and return to the format of the cell, the sample box is now blank and it doesn't even show a $ sign. I know the "0" is in the cell because i can see it in the formula bar. But on the sheet itself it does not display it.
View 3 Replies View Related