Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete formula
have a file with dollar amounts in two columns.
column A1 and column B1 want to match the prices in A1 to B1 and delete all the prices in column A1 that are the same in column B1 if the prices in column A1 is different than column B1 want to leave alone. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete formula
The whole row
For i = Cells(Rows.Count,"A").End(xlUp).Row to 1 Step -1 If Cells(i,"A").Value = Cells(i,"B").Value Then Rows(i).delete End If N ext i -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jason2444" wrote in message ... have a file with dollar amounts in two columns. column A1 and column B1 want to match the prices in A1 to B1 and delete all the prices in column A1 that are the same in column B1 if the prices in column A1 is different than column B1 want to leave alone. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete formula
how do I run this formula where do i type it in at?
"Bob Phillips" wrote: The whole row For i = Cells(Rows.Count,"A").End(xlUp).Row to 1 Step -1 If Cells(i,"A").Value = Cells(i,"B").Value Then Rows(i).delete End If N ext i -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jason2444" wrote in message ... have a file with dollar amounts in two columns. column A1 and column B1 want to match the prices in A1 to B1 and delete all the prices in column A1 that are the same in column B1 if the prices in column A1 is different than column B1 want to leave alone. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete formula
It's not a formula, it is VBA. Put it in a macro, then run the macro.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jason2444" wrote in message ... how do I run this formula where do i type it in at? "Bob Phillips" wrote: The whole row For i = Cells(Rows.Count,"A").End(xlUp).Row to 1 Step -1 If Cells(i,"A").Value = Cells(i,"B").Value Then Rows(i).delete End If N ext i -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jason2444" wrote in message ... have a file with dollar amounts in two columns. column A1 and column B1 want to match the prices in A1 to B1 and delete all the prices in column A1 that are the same in column B1 if the prices in column A1 is different than column B1 want to leave alone. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I delete the formula but keep the results | Excel Worksheet Functions | |||
Find and delete part of formula for multiple formulas? | Excel Worksheet Functions |