Jan 17, 2008

For Exempel

A1=B
A2=1
A3="="&A1&A2

I have even tried with concernate and indirect in A3 but no difference there...

I want A3 to return =B1 but it only returns it in text but i want it in form of a formula. Is there a formula that returns text directly into a formula or an easy way to do this?

## Get Formula In A1 Without Equal Sign?

Jul 11, 2012

i want formula in b1 to get the formula in a1 without Equal Sign

A1=(A2*A3)+2

Reults B1 should be (A2*A3)+2

## Place The Name Before Equal Sign

Oct 26, 2009

I'm trying to simplify a section of my code by naming a long string that is repeated. I tried by simply place the Name before equal sign (=) and also putting Set before the name. Both failed though I've seen both methods used successfully in other code. Am I having a syntax issue of some sort?

Private Sub ConditionalRowDelete()
Dim NumRows, iLine As Integer
ActiveSheet.UsedRange.Select
NumRows = ActiveSheet.UsedRange.Rows.Count
Dim CircuitType As Range
Set CircuitType = Range("C" & iLine).Value
For iLine = NumRows To 2 Step -1
If Range("A" & iLine).Value > "6999" Then
Rows(iLine).EntireRow.Delete
End If
Next iLine
For iLine = NumRows To 2 Step -1
If CircuitType = "VOIP" Or CircuitType = "Customer Care" Or CircuitType = "Dialup" Or CircuitType = "IRU" Then
Rows(iLine).EntireRow.Delete
End If
Next iLine
End Sub

## Copy Formatting Using Equal Sign

Jun 28, 2006

This seems simple...

If I let A1=8

If I fill in the cell green, either manually or with conditional formatting, and then copy and paste the cell into A2, A2 is now green with the number 8 inside.

However, if in A2 I type "=A1", A2 still has the 8 but is no longer green.

Is there a way to copy the formatting of a cell by setting it equal to the original?

## How To Add Equal Sign Automatically In The Entire Worksheet

Jun 11, 2009

Let me know how can a worksheet pick automatically equal = sign before manually feeding data

for example:

A B C
1 5+3 2+1 9+2
2 2+3 8+6 4+7

I want 8 in cell A1 and 5 in cell A2. I do not want to manually assigning/adding equal = sign to get sum 8 in cell A1

## If Cell Has Number Then Equal, Else Show Nothing

Sep 20, 2007

If square A1 says deposit account and c1 has a figure in it, i want g1 to repeat the figure,but if a2,a3 etc says something other than deposit account i want g2,g3 to remain blank.What is the formula for square g1etc?

## How To Show Minus Value In A Formula As Plus Sign

May 31, 2014

I have attached here an excel sheet with some data. I need to show the minus value in D5 as a plus sign, is there any conditional formula to work this out??

## Show These #### SIGN When The Sheet Is Printed

Jan 3, 2007

In A1 I have the time (military h:mm) 8:00
In B1 I have the 30 min braek we take at work 0.30
in C1 the end of shift time (16:00)
In D1 total hours (formula : = sum(C1-A1)-B1

and it is OK EXCEPT if the employee has the day off.
In that case A1 and C1 are empty but because of B1 I get in D1 the terrible ####

How can I remedy this ... this sheet cannot be edited in anyway. ( I cannot delete or edit anything)

Thought of an IF but the #### are not a value so I cannot do much in the way of conditional fprmats ... how not to show these #### when the sheet is printed.

## Show Plus Sign On Numbers Greater Than X

Aug 9, 2008

I'm trying to write a macro in Excel that would change any number greater than 10 in a spreadsheet to say "+10"

## Combine/Join 2 Cells Into 1 Cell

Aug 23, 2006

I have a document that has 3 colums.

Complete Name | Surname | First Name

The Complete Name is currently blank. The others just list the users Surname and First name. In the Complete name I need it to have Surname,Firstname - for example

Complete Name | Surname | First Name
Jordan,Michael Jordan Michael

Is there a Formula (Not Macro) that I can use to combine the Surname and First name cells to populate the Complete name cell with the surname,first name???

## Vba To Join Values In 2 Cells Into Another Cell

Sep 28, 2006

I am trying to write some VBA to join the values in 2 cells into another cell for a list, however my knowledge at this level is a little lacking. For each row in a list I would like to join the value of the cell of Column A and the value in the cell of Column B and write the output to Column C for that row, as shown in the attached example. Column C in the example shows the expected output.

## Join Text From Multiple Cells To One Cell

Apr 27, 2009

i know this is easy but i don't have an idea how to do it. I have dates written on column A1:A7 like

29-Mar-09
30-Mar-09
31-Mar-09
1-Apr-09
2-Apr-09
3-Apr-09
4-Apr-09

what I would like to do is how can I combine 29-Mar-09 and 4-Apr-09 into one cell...I would like the output to be placed in cell A8 appear as "29-Mar-09 to 4-Apr-09".

## Join Multiple Cells Into Single Cell

Jun 19, 2008

i need to copy the values from more than one cell and need to paste all the values in the single cell (if possible values seperated by commas).

## Map 2 Lists Of Data To Show If Equal

Dec 19, 2013

I need to map 2 reports to show if they are equal.

One report has 2 columns with name and amount of what was sent to a vendor.

The second report has 2 columns with name and amount of what they received.

The second report name column has account number added so the column won't be exact.

I need to compare the 2 reports to see if the same name and amount was correctly sent/received

Example:
Report 1 (sent)
Column 1-Name Sandra
Column 2-Amount \$100

Column 1-Name Sandra/284578
Column 2-Amount \$100

I am not sure how to display my findings. I would need to identify what is not matching.

## Shift Cells Up If Cell Equal 0

Dec 27, 2008

In the range A1:Y66, for every cell whose formula returns a 0, I want it to delete that cell and shift the cells up.

Here is the code I tried, but nothing happened:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column > 25 Then Exit Sub
If Target.Rows > 66 Then Exit Sub
If Target.Cells.Count > 1 Then Exit Sub
If Target.Value = 0 Then Target.Delete Shift:=xlUp
End Sub

## Hide Cell If Certain Cells Equal Certain Criteria?

Mar 22, 2014

The invoice itself simply equals cells from a drop down in the columns to the right hand side. (highlight yellow) What im looking to do is if any of the cells in column I equals - - i would like the cells b16:f16 to hide within the same row from the invoice and if there is something in column I that isn't - - i would like them to reappear.

## Cell V7 To Tell Me If The Number In U7 Is Greater Than Or Equal To The Individual #'s In Cells U7-U40

May 4, 2009

I am using cell V7 to input the formula but I want cell V7 to tell me if the number in U7 is greater than or equal to the individual #'s in cells U7-U40 and I would like it to put a 1,2,3 in the cells of V7-V40 for the three highest numbers in order of largest to smallest if is this possible?

## Add Formula To Cell To Equal Product Of 2 Other Cells Via Macro Code

Apr 18, 2008

I'm trying to set a cell on one sheet to be equal to the product of two cells on another sheet. The problem is that one of the cells on the other page is dependent on the variable T. This is what I've got and it's giving me errors

Worksheets("Output").Range("K14").Formula = "Worksheets("Calcs").Range("D17")*worksheets("Calcs").Range("D17").Offset(10+T,0)"

When I record a macro it gives me this, but again, I need the last cell in terms of "T"

ActiveCell.FormulaR1C1 = "=Calcs!RC[-7]*Calcs!RC[-7]"

## Decimal Sign Replaced With ';' Sign

Dec 8, 2009

I'm trying to solve a strange problem in a piece of code.

I have a variable that is define as Double called STD. When i try to insert that variable in a formula the decimal sign (for me a comma "," because I'm Portuguese) gets converted to ";" (which is for me the separation sign for the expressions in excel formulas. ex: AND(A1>0;B1>0)=TRUE). The code is:

Sep 29, 2006

My boss uses the + symbol and the = symbol in his formulas eg "=+E3*E4" What is the advantage or difference in this as to just using "=E3*E4"

Jan 10, 2008

In a formula, what effect does putting a plus sign after an equals sign? e.g.
=+((1+B8)^12)-1. I orginally assumed that it made sure that result the would always be positive but I was wrong.

Aug 6, 2014

=D7
=E7
=F7

so result:
= \$E\$7
= \$D\$7
= \$F\$7

A solution would be to use the "F4" every cell, but the process requires more time.

I tried to select multiple cells and press "F4" but do not works.

## Count If A Cell Is Equal To Cell In Different Spreadsheet And Is Less Or Equal Zero

Apr 17, 2014

How to correct my formula because it does not work?

Here the formula: =COUNTIFS(Data!C2:C24005,A17,Data!M2:M11149,"<=0")

I need to insert the formula in column C (Findings tab) which counts the rows in Column M (tab named "Data") that equal A17 (Column A in "Findings" tab) and which are less or equal zero. In addition if I drag the formula down I want to only the values be entered in highlighted in blue cells in column C (SKUs With Zero Sales in "Findings" tab) and empty cells in not highlighted cells. I attached images of these two tabs: Data and Findings.

## Join 2 Cells In VBA

Dec 6, 2007

I'm writing an Excel Macro and want to sum a number cell with the value "45667" and a text cell with the value "Prague" and return it to a new cell with the value " 45667 Prague"

I've done it successfully with the two text cells "John" and "Hopkins" to "John Hopkins".

This is my

Sub SumCells()

Dim FirstName, SecondName, Zipcode, City, fullname, fulladdres, space

FirstName = range("cell1").value
SecondName = range("cell2").value
Zipcode = range("cell3").value
City = range("cell4").value
space = " "

fullname = firstname + space + secondname
fulladdress = zipcode + space + city

The problem is that city is recognized as "Prague", and the zipcode as 45667 (without the "")

## Count Repeating SIGN Cells Only

Jan 9, 2014

I have a column that tells whether an adjacent cell is positive or negative. I'm trying to come up with a macro/formula that will tell me how long (# of rows going down) a negative or positive sign repeats before changing.

So it would go down the column and count the rows where the same sign repeats. Once the SIGN switches from + to - or - to + the number goes back to 0. Essentially counting the cells that move in one direction (+ or -).

For example. if A1 = +, A2 = +, A3 = +, A4 = +, A5 = -, A6 = + then it would count A1:A4 and output 4 in B4, meaning that the numbers have stayed negative for 4 rows. For A4:A5 nothing should appear as this sign change we don't want to record. Same for A5:A6. I don't know how to make a formula/macro to identify a repeating SIGN, and then dynamically count all those rows until the sign changes. Does this make sense? I've been beating my head against the desk trying to figure it out with no luck.

## Changing The Sign Values In Cells

Oct 29, 2009

i have one row of values ie c4="-121" d4="122" e4="123" f4="124"

and h4="test" like this .

if h4="right" (i change the value test to write) i want to change the

c4,d4,e4,f4 signs positive to negative

ie c4=+121 d4=-122 e4=-123 f4=-124

i write sample code like this

## Join Cells & Compare To Single Cells

Jul 5, 2007

i've put this previously on here with no results. There is a formula already in there though does not work because what I want to achieve is to have Column A & Column C to Match Column E & Column F, to Return the Value YES or NO. I�ve Highlighted in ROW 947 one that should Say NO yet Says YES.

## How To Join Cells In Different Columns

May 31, 2012

I have a list containing hundreds of rows and I need to join the cells in different columns.

Eg. Col A, Row 1 is "Red Maple"
Col B, Row 1 is "Acer Rubrum"
Col C, Row 1 is "60mm"

I need to join the row into one cell reading "Red Maple Acer Rubrum 60mm"

## Join Two Cells Of Data

Apr 20, 2009

I want to take a cell with a persons first name and a cell with their last name and combine into one.

EX.
What I have.
A1 B1
John Smith
Walt Smith

What I want.

A1
John Smith
Walt Smith

## Join Text To Cells

Jan 10, 2007

I have a column with numbers in each cell. I need to add the same three letters before each of the numbers. Example:

number in cell: 25067 I need it: ABC25067

I did a macro for it but had to do each one individually. I imagine there is a simple formula to do this automatically but I don't know enough to figure it out (despite reading up on it for the last hour!)