Over 1 million tech questions and answers.

Excel 2013 cell properties

Q: Excel 2013 cell properties

Hello,

We work with an excel sheet with multiple colleagues, This workbook is protected on some columns/fields and the workbook is shared.

Now we have several columns that keep changing it's cell properties. For instance:
Column: License Plate, this should have the property general, but every morning a colleague has to manually change it from date to general again, next morning the same thing.

This colleague has first removed the protection and share, next changed the column property and next put the protection and share on again. In my opinion the right procedure.

Does anyone have an idea what could be causing this?

Thanks in advance,
Wouter

RELEVANCY SCORE 200
Preferred Solution: Excel 2013 cell properties

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel 2013 cell properties

Read other 13 answers
RELEVANCY SCORE 85.2

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 85.2

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 76.4

I would like to have my list in excel have every other row of information a separate color so that the list is easy to read. (i.e. blue row, no fill row, blue row, no fill row, blue row, no fill row, etc.) I would like to be able to sort the data in this list without the color of each row sorting with the information. Is it possible to lock the fill properties of cells so that it does not sort along with the information in that cell?
 

A:Excel Sorting without cell properties changing

Here's how.

Select however many rows you need (click'n'drag on the row headers).

Choose Conditional Formatting from the Format menu.

Set Condition 1 to Formula Is. In the box, enter

=MOD(ROW(),2)<>0

Click the Format button. On the Patterns tab, choose a suitable blue. Click OK. Back in the previous dialog, OK again. The formatting will not be affected by Sort.

Rgds,
Andy
 

Read other 1 answers
RELEVANCY SCORE 76

Hello,

I am beginning to suspect this is not possible. What I want is to have a column with "notes" in which the cells (and the rows with them) expand downwards to accommodate additional text. Can this be done? All the online tutorials just seem to think people want lots of nice additional empty white space at the top of the cells when they change the cell height!

Am I missing something? And can anyone help?

A:Changing cell height in excel 2013

just select text wrap. Column will get longer not wider though. The effect will be visible after you will finish cell editing or of you preformat cell height then all will be as you write (assuming that cell is correctly pre-formatted)

Read other 2 answers
RELEVANCY SCORE 76

Hello there,

I have some users here in the company who work in the same Excel file. It is used for Logistics planning for different countries.
The file is shared and some columns/cells are protected against editing, to prevent the removal of formula's etc.

Now every morning the colleague that manages the file has to restore almost half the sheets because the cell properties are scrambled. Cells that have a value general are changed into currency cells.

This colleague then unshares and unprotects the excel sheets and then restores the cell properties. Next the protection and share is added to the file again.

I do not believe these cells magically change by themselves, But how can we resolve this issue?
I am thinking of a bug in Excel 2013 (maybe the combination of protection/share). And am weirded out by this...
 

Read other answers
RELEVANCY SCORE 76

Hi guys,
almost a month ago I was working on a file on Excel 2010 (whose cells were 15 x 8,43), when all of a sudden Windows asked me to install the so-called "Windows 10 anniversary" update and, when I went on to open the file, I found out the cell width had gone from 8.43 to 8.38. As a result, only columns A through R would show on one page (before it was columns A through half of U), because each of them had gotten larger: I guess it was because 8.43 = 64 pixels and 8.38 = 72 pixels (so the number of pixels had increased)!

I thought it was an issue with an "old version" of Excel, so I uninstalled Office 2010 and had Office 2013 installed instead... and just the opposite happened: originally the cells were 15 x 8,38 (by default), but a second "Windows 10 anniversary" update last Friday brough the width back to 8.43. This is a problem, because I'm adding a bunch of pictures to my file in order to make them fit the cells containing them, and this constant width changes jeopardize that.

I've found out that "When using ClearType with the Windows Anniversary update, Excel column widths can be larger than in earlier versions of Windows. This happens in only some fonts, such as Calibri. It can affect all versions of Office 2016", so I have disabled ClearType and installed the fix (Windows update KB3197954). Now I'm stuck with blurry text all over my screen (no ClearType) and a grid whose cell width is 8,43 (which I assume was the "rig... Read more

A:Is default cell width for Excel 2013 8.43 or 8.38?

Anyone? Anyone at all?

Read other 9 answers
RELEVANCY SCORE 67.6

In cell j, I have formula =IF(SUMPRODUCT(ISNUMBER(SEARCH("VLXP",K2:AB2))+0)>=1,"Yes","No") that returns yes or no if VLXP is contained in any cell K2 through AB2 and it works correctly. What I would really like to do is then put into cell j the entire matching cell content or if not found return n/a. Is there a way to accomplish this maybe with VBA?
 

A:Solved: Excel if cell contains vlxp then put matching cell data in current cell

Read other 6 answers
RELEVANCY SCORE 65.6

Hi, all!

I wish to purchase an HP dv5000t series laptop with a 12 Cell Li-Ion battery, but I saw a diagram on the HP site which showed a bulky mass at the back of the laptop, compared to a 6 cell which did not have this. It seems that such a laptop will not be able to sit flat on a desk.

Does anybody know from experience if this will be the case? If so, how bad of an angle is it? Will it interfere with normal use, etc?

Thanks! Your help is appreciated.
 

A:6 Cell Li-Ion Battery vs. 12 Cell (Physical Properties)

If HP sells the battery with the laptop then it'll work. While it may not sit flat that isn't a problem.
 

Read other 3 answers
RELEVANCY SCORE 65.2

hi, i have 2-excel cells in the same sheet, both contain manually entered numbers; cell-2 changes frequently; if the existing entry in cell-1 is < than the new entry in cell-2, cell-1 should immediately reflect this new value. how do you create this formula?
 

A:Solved: excel-replace content of cell-1 if cell-2 is > cell-1

Read other 8 answers
RELEVANCY SCORE 60.8

I have a sheet with 2 simple columns: Date and Price. I have imported the dates (##/##/####) and the prices ($###,###) by copy/pasting from the search results given to me by a niche database program I use. When the cells paste in, they all have the format "General".

When I try to format the "date" column into dates, it _does_ change the format as far as the cell is concerned, but the content of the cell doesn't adapt to the new format. For example, I have the date as 3/05/2001 and when I change it to a date format of MMM D, YYYY the content should change to March 5, 2001 but it doesn't. It is as if all the cells are forced to stay as text regardless of what the formatting is that I'm applying.

Same problem with the price column: if I change the format to include 2 decimal points, that format does apply to the cells, but the content of each cell remains without a decimal or anything following, as if the content is just text.

I have like 1000 rows in each column, and plan to do this analysis of the database's results frequently, so I'm hoping the answer isn't just to retype the data. There's got to be a way to copy/paste or export or something. Maybe I could copy/paste into notepad first to scrub out any formatting or locking from the niche database program?
 

A:Excel 2007 Cell Values Won't Take On Characteristics of Newly Applied Cell Format

Good news: Made some progress. In thinking that maybe each value had the textual single-quote forcing it to act like text, or maybe if I find/repaced all the dollar signs and commas that had been imported, I accidentally discovered that each and every value in my imported columns has a following space!

Bad news: Seems like Excel has a bug that thinks that if I say "Find=[singleSpace]" "Replace=[null]", then I should be given an error saying "Excel cannot find any data to replace". I think I'm doing the find/replace correctly because it worked on the dollar signs and commas.

Anybody know a workaround for the bug?
 

Read other 1 answers
RELEVANCY SCORE 60.8

I'm attempting to write my first macro for an Excel 2003 workbook. I'm not completely code illiterate (I've got moderate skills with AutoLISP), but I'm new to VBA and am not yet an Excel power user, so please be gentle.

The macro I want to write will:
check that the selected cell's content is underlined before proceeding
copy the content of the currently selected cell into an external plain text .log file
.log file lines should be: year/month/day - time - username - cell contents
.log file names will probably need to be generated
clear the cell's content and formatting (particularly underline and text/background color)
Here's what I have so far:
Code:
Sub Unpost()
If Selection.Font.Underline = True
Then Selection.ClearFormats And Selection.Clearcontents
Else
If MsgBox("The selected cell is not underlined...are you sure?", vbOkCancel) = vbOk
Then Selection.ClearFormats And Selection.Clearcontents
Else Exit Sub
End If
End If
End Sub
If I've written it correctly, it should currently do everything except log the cell contents. This, from what I've seen, is going to be the trickier part. I intend to use this macro 50+ times per weekday, so at some point the .log files will get too long to be useful, so I assume it will need to automatically create new logs (perhaps "year-month.log"). I've seen some useful info about appending to an external log here and here, ... Read more

A:Excel 2003 macro: log contents of selected cell, clear cell

You need to use the "File Scripting Object" to create and/or append text to a file. I've included a link below to get you started. If you are unable to figure it out on your own let me know and I'll write the code for you.

http://www.virtualsplat.com/tips/visual-basic-fso.asp

Rollin
 

Read other 1 answers
RELEVANCY SCORE 60.8

I'm working on a spreadsheet at the moment which displays a range of cells all containing values referenced from another spreadsheet (within the same workbook). This system works fine.

Every day, the original worksheet is updated. So, it has fields already arranged up until the end of the year. A row for every date. Now, needless to say, rows for dates in the future contain no values, and so when the spreadsheet I am working on now references those cells, it displays "$0.00" (which is correct, given I am dealing with financial figures).

Now, all of that works as expected, however, on the spreadsheet I am working on, all of those figures are displayed in a line graph. This line graph, at todays date, shows an enormous drop given that the fields for the rest of the year all show a zero balance.

What I need to do, is to get the remainder of those fields (every field that says "$0.00") to not display anything at all. So, if the value is $0.00, it would not display a value at all, and therefore not show anything on the graph.

Can someone tell me how I can achieve this? I'm sure it can be done with an "if" statement, but I'm not sure how to structure it.

Any help would be greatly appreciated.
 

A:Solved: Remove Cell Value If Cell Value Is Zero (Microsoft Office Excel 2007)

=If(a1="","",Sheet1!a1) and drag it down.

Where a1 is the first cell in spreadsheet you are working on, and sheet1!a1 is the sheet within workbook containing figure.

Not sure if the graph will recognize the "blank' cell as blank or "0"
You could try that

Pedro
 

Read other 3 answers
RELEVANCY SCORE 60.4

Using EXCEL, I have a need to copy the cell contents from upper cells in col. A down a few rows in col A. There are various changes in data in col A as you will see below. The periods in the following info are used as placeholders only. B1, A2, A3, A4, etc. are blank. I need a formula because I have 60,000 records in the spreadsheet. Thanks in advance.

Here is how the data looks now.

....A.....B
Apple.........
..........Fire
..........Ice
..........Snow
Peach
..........Sleet
..........Rain
..........Fog

Here is how I want the data to look

...A ...........B
Apple
Apple.......Fire
Apple.......Ice
Apple.......Snow
Peach
Peach.......Sleet
Peach.......Rain
Peach.......Fog
 

A:[Excel] Copy And Paste Upper Cell To Lower Cell

With the workbook open press ALT + F11 to bring up the Visual Basic Editor. Once the VB editor opens, click INSERT --> MODULE and paste the code below into the blank module. Close the VB editor and select the first cell in column A containing your data you want to copy down. Click TOOLS --> MACRO --> MACROS and select the macro from the list and run it. This macro will copy all your data except for the last value in column A because without actually seeing your workbook, I have no way knowing which line to stop at. Therefore, the code will end when it reaches the last value in column A.

Code:

Public Sub CopyData()

Do Until ActiveCell.Row = Cells(Rows.Count, "A").End(xlUp).Row

ActiveCell.Copy
ActiveCell.Offset(1, 0).Select

Do Until ActiveCell.Value <> ""
ActiveSheet.Paste
ActiveCell.Offset(1, 0).Select
Loop

Loop

End Sub


Rollin
 

Read other 2 answers
RELEVANCY SCORE 60.4

Hello,

I cant seem work out a solution for what I'm trying to do. I have an Excel workbook that has multiple sheets. On sheet 1 i want the data from cell "G3" to be copied onto sheet 2. But i want the location on sheet 2 to be based on whatever was entered into cell "D3" on sheet 1.

For example: Sheet 1, cell D3 I have the name John, in cell G3 i have 68. I want "68" to be pasted in sheet 2 in cell B26.

But if the name in Sheet 1 cell D3 is Suzie, then I want G3 to be pasted in Sheet 2 in cell D26. So I would need to identify the paste location for each person.

I want the data to paste to the next cell so that the next entry can be pasted below the last entry for that person (for John the first entry would go into cell B26, then the next entry would go into cell B27 and so on).

But i want it to be a specific range, i dont want data to be pasted past 20 cells (cell B45). If possible a message box could be created to let the user know that the max is reached.

I would appreciate anyone's help with this as i have been struggling for awhile to try to get this. Thank you
 

A:Excel - Copy paste cell into range based on another cell

Read other 12 answers
RELEVANCY SCORE 60

Using Excel 2003 in Windows XP

I would like to use the contents of one cell as the destination location for copying data.
For example
I have 2 worksheets 1) Results and 2) info
in info
A1 = 'ABC'
C1 = 'Results!O54' < this is calculated based on other data in sheet.

Using a macro, I'd like to copy contents of A1 to cell location 'Results!O54' more specifically to where ever C1 points... C1 will change based on other data in info sheet.

The macro record for action looks like this (but I would like the 'O54' to be based on contents of C1 which changes)
Range("A1").Select
Selection.Copy
Sheets("Results").Select
Range("O54").Select
ActiveSheet.Paste
Sheets("info").Select

There is more to it then that but I think this is where I am stumped.
 

A:Solved: Excel: Uses contents of Cell to select a cell

Sheets("info").Range("A1").Copy Destination:=Sheets("Results").Range(Sheets("info").Range("C1").Value)
 

Read other 3 answers
RELEVANCY SCORE 58.8

I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always start by saving my most recent version of the workbook with the date I last updated it in the filename, and then when I finish my updates for the day, I save the current day's updated workbook with the current day's date in the filename, etc. So after a while, I've got quite a stack of versions of the same workbook, albeit with slightly different data in some of the cells, from version to version.

Near the end of the year, it'd be neat to be able to compare the beginning and end of year versions, cell by cell, to see what changed.

Ideally, I'd like to sort of "subtract" one workbook from the other, cell by cell, and display something in the results that shows cells that differ btwn workbooks and cells that don't.

Obviously, I could just print the two versions, and plow through them both, side by side. But they're nearly 2,000 rows deep, all things considered, and with all the data we compile for each member, each row goes up to column AT! That's a lotta data to compare visually cell by cell.

Is anything like what I'd like to do possible?

Thx.

A:Can I compare 2 Excel spreadsheets cell by cell?

I think this might help if I read this correctly. I used this before to compare three lists I made a long time ago, then when I needed to update them I didn't want to sift through hundreds of entries.

Compare Two Lists in Excel - Easy Excel Tutorial

From MS https://support.microsoft.com/kb/213367

Also 4 Ways to Compare Data in Excel - wikiHow

Read other 1 answers
RELEVANCY SCORE 58.8

Is there a way to copy a col of formula's/math cells to a new col without excel modifying the coordinates?

Scenario: 150 cells of diff equations "located from a1 thru a150" you wish to move to d1 thru d150.

Problem: Excel modifies the coordinates of each pasted formula rendering garbage.

Individual f2, highlite,copy and then paste takes too much time if there are thousands of formulas to move.
thanks, nt
 

A:Copy cell to cell without excel modifying

Use absolute instead of relative references, ie:

$A$1:$A$150

Rgds,
Andy

EDIT: better explanation. You have 5 in A1, and the formula =A1 in B1. If you copy B1 to C1, C1 will read =B1. But if you make B1 =$A$1 and then copy it to C1, it'll hold.
 

Read other 1 answers
RELEVANCY SCORE 58.8

I have two cells, Cell "A" and cell "B", that have a formula in each. Cell "A" has a value that is correct and Cell "B" has a value that is correct. I now have a third cell (cell "C") with a formula that takes the values of cell "A" and cell "B" and multiplies them. The value of the product is wrong in cell "C" as compared to a value performed by a calculator. Cell "C" reports 51,550.64 whereas the calculator reports 51,540. What is the problem.

Thanks
 

A:Excel cell to cell multiply problem

I'm willing to bet that the number you are entering into the calculator are rounded off while the number that Excel is using is not truly rounded off. Even though Excel may display a certain number in a cell due to its format, it is probably using the true value of the number which probably includes several decimal places. What numbers are showing in cells A and B? How are cells A and B formatted? What happens if you increase the number of decimal points in these cells...do the cell number become larger? If so, then Excel is likely using the true values of the cells instead of the display values in its calculations. Provide details of how you are obtaining your cell values so we can confirm that this is happening.

Try the following

TOOLS --> OPTIONS and choose the Calculation Tab. Put a check in the box marked "Precision as Displayed."
NOTE: This will affect all other calculations on the workbook causing changes to other values on the sheet!

Rollin
 

Read other 3 answers
RELEVANCY SCORE 58

I am looking for a way to change the color of text in a range of Excel cells, based on a formula. If F4:F(end of sheet) is 5% less than cell E4:E(end of sheet, same row as F), change text color to red. If it is 5% more, change text color to blue. If neither condition is true, leave text color black. Is this possible? I was pretty sure it is using VBA, but was unsure how?
 

A:Conditional cell properties

It is. I did something similar years ago and have forgotten the details - but I do remember I based it on one of the sample VB scripts supplied with XL
 

Read other 3 answers
RELEVANCY SCORE 57.2

Good day:

I create pdf fillables using Adobe Pro 10. I have modify some cells to 6 point helvetica, left, multi-line. All the cells work in the table, but the last cell. It will not multi-line. Would anybody know why?

Thanks
 

Read other answers
RELEVANCY SCORE 54.4

Hi,

For a 'Yes/No' data type, my MS Access 2013 does not allow me to change from the default 'check box' to the 'text box' option under lookup field properties - display control. It was originally able to but I think something has happened to it.

The problem is not table or database specific as I have tried other tables and databases. I even reinstalled MS Access to make sure it was not the application's fault. It still exists and I don't know what went wrong.
Could someone please advise?

Thanks a lot.
 

A:MS Access 2013 Yes/No Lookup field properties can't select Text box

lycen, welcome to the Forum.
I am not sure how you managed to change it to a text field, as you can't do it in Access 2007, only to other types of "On/Off" type fields
 

Read other 3 answers
RELEVANCY SCORE 54

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
 

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"
 

Read other 1 answers
RELEVANCY SCORE 54

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.
 

A:Solved: Excel search does not work Excel 2013

Read other 7 answers
RELEVANCY SCORE 50

Office 2010/Excel I accidentally entered an email address into a cell and now I can't get rid of that format in that cell. No matter what I do, whenever I try to enter text into that cell it is always illuminated in blue and is underlined, just like email addresses are.
How can I make this cell into a 'normal' one again?
Thanks.

A:Excel cell

I have Office 2007. In the Home tab is there a "Styling" option like this?

Highlight the cell and click Normal.

Read other 3 answers
RELEVANCY SCORE 50

I want to use the value typed into cell D5 in later code. It is a value from a list and I want the code to find the value of D5 so that it can locate where to copy the information to.

Can anyone help?
 

A:Cell Value VBA Excel

Please post your existing code and/or sample workbook.

Rollin
 

Read other 1 answers
RELEVANCY SCORE 49.6

Is it possible to change the color of a cell using a formula in Excel?
 

A:Cell color in Excel

Read other 13 answers
RELEVANCY SCORE 49.6

Anyone know if / how to make a cell in an Excel worksheet "blink"? I want to catch the attention to the cell I want others to fill in.

Thanks for your help.
 

A:Excel - blinking cell

I don't think this ism possible, you could however add some code so that when the sheet is activated a small routine runs two or three loops and changing the background color making it look like blinking adn if necessary have the cell keep this color if needs attention adn when the cell is corrected the on change routine would reset it to the default background.
 

Read other 1 answers
RELEVANCY SCORE 49.6

Sub NewInvoice()
' THIS PART WORKS OK!!!!
' Will replace Ctrl+n with "when workbooks opens do this"
' got that part ok already.
'
' NewINvoice Macro
'
' Keyboard Shortcut: Ctrl+n
'
' get new number for invoice
'
Dim x As Integer
Workbooks.Open Filename:="d:\number.xls"
x = Workbooks("number.xls").Worksheets("Sheet1").Cells(1, 1)
' Sheets("Quote").Activate
ThisWorkbook.Worksheets("Invoice").Range("n4:n4") = x
x = x + 1
Workbooks("number.xls").Worksheets("Sheet1").Cells(1, 1) = x
Workbooks("number.xls").Save
Workbooks("number.xls").Close

' I need HELP!!! here.....I'll write in plain English what I want to happen.
' Can somebody please write it so it works???

' select n4
' save current file (invoice.xls) using "File menu, Save As"
' use the contents of n4 as the filename.xls
'
'
' eg: n4=2 so new filename is 2.xls leaving original "invoice.xls" as blank
' so that when finished editing invoice, on close of Excel it asks do you want to save changes?
' tell it "yes" and it saves as 2.xls not overwriting invoce.xls

' any help would be much appreciated!!!!!
End Sub
 

A:Excel. Using cell value as new filename.

How about you save invoice.xls as invoice.xlt instead? that way, you have the template, doubleclicking it will open a new xls doc based on that template.
But, that will not allow you to save the file in the manner you want, for that, you will have to add the following to your code:

ActiveWorkbook.saveas Filename:=Range("n4").Value

see if that works
 

Read other 3 answers
RELEVANCY SCORE 49.6

In cell B5: 54.5 3L 1-39.16

In order to extract the 3 that is next to "L" in the middle
of the text, I made up the following formula:
=IF(R4>1,MID(B5,(FIND(" ",B5)+2),LEN(B5)-((LEN(B5)-FIND
("L",B5)+1)+((FIND(" ",B5))+1))),IF(R4=1,-MID(B5,(FIND
(" ",B5)+2),LEN(B5)-((LEN(B5)-FIND("L",B5)+1)+((FIND
(" ",B5))+1)))))

(Please note: there is a condition set for a value in cell
R4 too (If R4 is greater than 1). And also the text in the
B column which B5 is a part, varies in length, so the formula did get a bit clunky).
Anyway, I end up with "3" displayed in the cell that contains the above formula, as I wanted.

Say the formula that produces "3" is in cell S4: If I enter: "=S4" in another cell, excel doesn't seem to recognize "3" as S4 value. All I get is "=S4" in the new cell!

I can't do anything with it. Excel does not seem to
recognize the value "3" from the above formula. So can't use its value in another cell.

Is there a way to get around this? I have formatted the
cell to General, Number, etc. Doen't seem to make a
difference.
 

A:Excel does not seem to recognize a cell value.

Hi Brendon,

Try changing the formatting to General, then select the cell above S4 and then do a Find>Replace. Replace = with = and see if that fixes it. Don't ask me why, but I had the same problem before, and this solution was given to me by an Excel MVP at another help forum. It worked like a charm for me.

Good luck,
Richard
 

Read other 3 answers
RELEVANCY SCORE 49.6

Hi,

In Excel can you have two formulas for one cell? On the example below, I need to have it so it goes +100% if they are over their goal but -100% if they fall below. I have the conditioning rule for the negative to go red.

Varietal Ship Goal Shipped +/- Percent of Goal
Chard 385 602 156%
T Chard 32 9 -72%

Also, for some reason the other person who works on these files along with me, cannot highlight the row if there is a conditioning rule anywhere? Any thoughts on this as well would be quite helpful. Thanks in advance!
 

A:Excel - Two Formulas, One Cell

Hi, welcome to the forum.
Two formulas is a no no, but the formula can have nested IF and OR statements, your example is not quite clear (to me)
About highlighting, if conditional formatting is actie in that cell you can change and hightlight what you want, conditional formatting overrules this.
 

Read other 2 answers
RELEVANCY SCORE 49.6

I am trying to return the value of the last completed cell in a row.

Using arrays, I've tried lookup, but it doesn't seem to like a formula as the critera. Match returns the position in the array, but not the value.

This is for a spreadsheet that is updated monthly--not necessarily on the first of the month so logic using dates won't work. I trying to create a summary table to automatically use the latest entries from the spreadsheet.
 

A:Excel-value of last nonblank cell in a row

Match will get you the row number, so use it in the Index function..

=Index(array,Match(),colnum)

So I'm not reinventing the wheel, Bob Phillips has a nice write-up on it...

http://www.xldynamic.com/source/xld.LastValue.html

HTH
 

Read other 3 answers
RELEVANCY SCORE 49.6

I am trying to populate some cells in excel from sheet1 to a continuous column cells in sheet2... so I would like to do is use vlookup to find the next non-blank cell in a range on sheet 1 and populate a column in sheet 2 from top to bottom. this is what I have so far.
=IF( AND( NOT( ISBLANK(Estimate!D3) ),$I$36=TRUE),VLOOKUP(Estimate!D3,Pricing!$C$4:$G$200,2,FALSE),"")

=IF( AND( NOT( ISBLANK(Estimate!D4) ),$I$36=TRUE),VLOOKUP(Estimate!D4,Pricing!$C$4:$G$200,2,FALSE),"")
 

A:excel next non-blank cell

got it figured out. see below.

=IF(A2<$K$35,"0.00%", IF(A2<$K$36,-$J$35, IF(A2<$K$37,-$J$36,IF(A2<$K$38,-$J$37,IF(A2<$K$39,-$J$38,-$J$39)))))

thanx for your help
 

Read other 1 answers
RELEVANCY SCORE 49.6

I have HTML in a cell. There's something like this in the cell:

Code:
<a href="http://www.google.com">Google</a>
I want to get the web address from that cell and put it into another cell (I assume I use a formula). Any idea?

It is also possible the cell may contain multiple URL lines like that, and I would like for each extra URL for it to be put in a new cell.
 

A:Excel: Get certain text from cell?

Read other 6 answers
RELEVANCY SCORE 49.6

i enter a whole number (any cell) and the result is a decimal number.
ie: enter 4 - result .4
have tried diffirent things with no change.
 

A:excel - cell format.

Read other 7 answers
RELEVANCY SCORE 49.6

Range("A2").end(xldown)

If I want to move to next cell, what statement i have to write.
want the next cell in downwards directions as using Range("A2").end(xldown).next.select takes me towards right direction
 

A:Excel-Moving to next cell using VBA

Hi and welcome. Let me move you to business applications for better assistance.
 

Read other 3 answers
RELEVANCY SCORE 49.6

Quick question,

Can I fill a cell on Excel with something other than just solid color? Maybe crosshatching or some other pattern? I'm using Excel 2000.

Thanx!
 

A:excel cell fill

Originally posted by T-Bone:
Quick question,

Can I fill a cell on Excel with something other than just solid color? Maybe crosshatching or some other pattern? I'm using Excel 2000.

Thanx! Click to expand...

Have you tried Format/Cells/Pattern, click on the Pattern button at the bottom of the window?
 

Read other 2 answers
RELEVANCY SCORE 49.6

I would like to know if it is possible to set up tabs so that I can hit the tab button and go from (eg) A3 to G7 to B18 with out setting up buttons
 

A:cell movement in excel

Read other 12 answers
RELEVANCY SCORE 49.6

I have 6 columns which have hours & minutes worked per day, eg; 8h 37m. In the 7th column I want to add these together & have the result displayed as h & m.
In the 7th column I right clicked, format cells, custom, h.mm, okay., I then clicked the cell & in the text bar entered .... =SUM(C2:H2)., but the answer does not appear as hours & minutes.
Also once these formula's are entered can I click & drag over multiple rows.

Thanks in advance
 

A:Excel 2 Formulas' in 1 cell

It sounds just like you want to join the text string up. You do this by putting an & between the cell references you wish to join

=A2&B2&C2&D2&E2&F2

you might also type:

=CONCATENATE(A2,B2,C2,D2,E2,F2)

It's not a mathematical / summing function because there's no way of excel knowing that what you are stringing together is time related.
 

Read other 1 answers
RELEVANCY SCORE 49.6

Hi,
In Excel, I have a macro which, when ran, resets the last used cell, so that when you press CTRL + End, the last cell (bottom-right) that contains data is selected.

Here's the code:

Sub Reset_Range()
ActiveSheet.UsedRange
End Sub

However, sometimes this doesn't work. I run the macro and the 'active cell' is an empty one way off away from the data. Presumably this is because something's been in those now-empty cells previously. Maybe the have cell formats or something, and it stops the macro from working correctly.

E.g. I have a file with data in cells A1:K6154. Before, and after, running the macro, pressing CTRL + End takes you to cell K8621.
If I delete the rows 6155 to 8621, re-run the macro and press CRL + End, it still takes me to K8621.
If I delete the cells A6155 to K8621, re-run the macro and press CRL + End, it works correctly and takes me to K6154.

Can the code be modified so that for cells to be within the "used range", they must have an actual value in them?

Cheers.
 

A:Excel VBA - setting last used cell

If your range is in a block, and always set to the leftmost column (ie. Column A) then perhaps you would consider using this to select the rightmost in the last row of your range...

Cells(Application.Rows.Count, 1).End(xlUp).End(xlToRight).Select
 

Read other 3 answers
RELEVANCY SCORE 49.6

I have a few cells i need counting in excel but i need them to perform a certain job. I need to count 2 cells that have data in them to total 1. If there are blanks in the cells i need it not to count them. Below is an example.

Cell L2 Blank Cell M2 blank Cell O2 29 Cell P2 25.

I need this total to total 1 for the 2 full cells of O2 and P2.

Then after that any 2 cells together ie R2 and S2 adds 1 to the total providing that both cells are full.

to explain beter I'm doing a darts spredsheet keeping totals so i need 2 full cells to total a game win of 1. Then every 2 cells full after will be game win 2,3,4 etc.

I hope someone can help.

Many thanks
 

A:cell counting in excel

It's better if you post a sample spreadsheet, showing where the totals (1s) need to go.
If you click on "Go Advanced" below the Quick Reply window you can upload a file.
 

Read other 1 answers
RELEVANCY SCORE 49.6

I want to ad 20% to the same cell I'm typing the value in, how do I do that ?
Example: I type 100 in cell L2 and when I move away from L2 it should add 20% and show 120.
 

A:Excel: Add % value to same cell as you type in

Only way I can see is to add a helper column with formula in the column where figure would normally go.
Suggestion attached

Pedro
 

Read other 2 answers
RELEVANCY SCORE 49.6

EDIT (Again): ok, saving is working now too. Even thuogh I don't actually know what was wrong with my original code

EDIT:
Reading is working now but saving isn't. Please help me figure out how to save my spreadsheet. I'm calling:

inputBook.Worksheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
sheet = (Microsoft.Office.Interop.Excel.Worksheet)((inputBook.Worksheets).get_Item("Sheet1"));

((Microsoft.Office.Interop.Excel.Range)(sheet.Cells[row, column])).Value2 = "some text";

book.SaveAs(output, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
it saves, but the .xls file is completely empty. Please help me solve this!
>Original Post:
>
>
>I need to read cells' values in C#, from a spreadsheet. That's pretty much it. I need to be able to write to them later too, but I can't even get Read to work. Here is my whole code:
>
>
>string input = @"C:\Users\James\Desktop\foo.xls";
>Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
>Microsoft.Office.Interop.Excel.Workbook inputBook = app.Workbooks.Open(input, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true... Read more

Read other answers
RELEVANCY SCORE 49.6

I'm creating a database on excel to work out my incomings/outgoings etc.

I have a row with titles on. How do I keep those visible while a scroll through everything else? Someone who knows how to do this should know what I mean.

-Jack
 

A:Excel cell problems

Read other 7 answers
RELEVANCY SCORE 49.6

I HAVE TO FORMULAS THAT I NEED TO ADD TO ONE CELL BUT NEED THEM TO INDEPENDENTOF EACH OTHER

=IF(AND(G4="DARK RED INCLINING",H4="GREEN ABOVE RED",I4="GREEN"),"LONG","NO TRADE"))

=IF(AND(G4="DARK GREEN DECLINING",H4="GREEN BELOW RED",I4="RED"),"SHORT","NO TRADE"))

AS YOU CAN SEE IN F4 AND F2 WHAT IM TRYING TO DO
1 MORE THING HOW WOULD I THEN MAKE F COLUMN DO IT FOR ALL CELL WITH OUT CHANGING THE INDIVIDUAL ROW NUMBER IN THE FORMULA
 

A:Excel - I Have Two Formulas I need to Add to One Cell

Read other 7 answers
RELEVANCY SCORE 49.6

I have already got the connection between the excel and the PPT open in my current code, and I am running a loop to add slides to the ppt based on another cell value. But, I now want to add a section of code to the loop that will look at the slide for the

OLEFormat.Object named "PageTitle" and replace the placeholder text with the

xlWB.Worksheets("Title").Range("C" & i).value from excel.

Any suggestions?
 

Read other answers