Tjyylli

Should I use acronyms in dialogues before telling the readers what it stands for in fiction?

In the 1924 version of The Thief of Bagdad, no character is named, right?

Relation between independence and correlation of uniform random variables

What does "Four-F." mean?

Does the attack bonus from a Masterwork weapon stack with the attack bonus from Masterwork ammunition?

Do I need to consider instance restrictions when showing a language is in P?

How do hiring committees for research positions view getting "scooped"?

Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?

Matrix using tikz package

Can a wizard cast a spell during their first turn of combat if they initiated combat by releasing a readied spell?

Optimising a list searching algorithm

When to use snap-off blade knife and when to use trapezoid blade knife?

Light propagating through a sound wave

Worshiping one God at a time?

Turning a hard to access nut?

Hausdorff dimension of the boundary of fibres of Lipschitz maps

Variable completely messes up echoed string

How to define limit operations in general topological spaces? Are nets able to do this?

Wrapping homogeneous Python objects

Generic TVP tradeoffs?

Do native speakers use "ultima" and "proxima" frequently in spoken English?

I seem to dance, I am not a dancer. Who am I?

Can a medieval gyroplane be built?

How are passwords stolen from companies if they only store hashes?

Deleting rows based on a criterion in another column

Obtain value from another column based on selected list valueConditional Formatting in excel based on another columnCount first occurrence of one criterion based on a second criterionExcel - find multiple pieces of data in several different columns at onceExcel: Calculate IF column based on another IF columnReducing rows in column to match another column in ExcelIn Excel have a cell read specific text when two others equal a certain valueHow to delete rows in excel based on column valuesSubtracting sales from order in excelExcel 2013 FIFO Report based on Log

0

I have data from sales transactions and I want to delete voided transactions. The problems is that some voided transactions have multiple items. Three examples are (included in columns A through F):
Tran.# Tran. Quant. Product Code Desciption
1008818 1 1 1 44370

1008818 1001 0 0 0 ******* VOID SALE *******
1008834 1 1 1 34880

1008834 2 1 1 63045

1008834 1001 0 0 0 ******* VOID SALE *******
1009142 1 1 1 23700

1009142 2 1 1 45770

1009142 3 1 1 63244

1009142 4 1 1 63237

1009142 1001 0 0 0 ******* VOID SALE *******

I need to delete transactions 1001, but I need to delete all items of the transactions. Is there any easy way to do this (functions, macros, etc.)? If yes, can someone give me the solution or macros?

worksheet-function microsoft-excel-2010 macros

share

asked 5 mins ago

HootanHootan

1

New contributor

Hootan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have data from sales transactions and I want to delete voided transactions. The problems is that some voided transactions have multiple items. Three examples are (included in columns A through F):
Tran.# Tran. Quant. Product Code Desciption
1008818 1 1 1 44370

1008818 1001 0 0 0 ******* VOID SALE *******
1008834 1 1 1 34880

1008834 2 1 1 63045

1008834 1001 0 0 0 ******* VOID SALE *******
1009142 1 1 1 23700

1009142 2 1 1 45770

1009142 3 1 1 63244

1009142 4 1 1 63237

1009142 1001 0 0 0 ******* VOID SALE *******

I need to delete transactions 1001, but I need to delete all items of the transactions. Is there any easy way to do this (functions, macros, etc.)? If yes, can someone give me the solution or macros?

worksheet-function microsoft-excel-2010 macros

share

asked 5 mins ago

HootanHootan

1

New contributor

Hootan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have data from sales transactions and I want to delete voided transactions. The problems is that some voided transactions have multiple items. Three examples are (included in columns A through F):
Tran.# Tran. Quant. Product Code Desciption
1008818 1 1 1 44370

1008818 1001 0 0 0 ******* VOID SALE *******
1008834 1 1 1 34880

1008834 2 1 1 63045

1008834 1001 0 0 0 ******* VOID SALE *******
1009142 1 1 1 23700

1009142 2 1 1 45770

1009142 3 1 1 63244

1009142 4 1 1 63237

1009142 1001 0 0 0 ******* VOID SALE *******

I need to delete transactions 1001, but I need to delete all items of the transactions. Is there any easy way to do this (functions, macros, etc.)? If yes, can someone give me the solution or macros?

worksheet-function microsoft-excel-2010 macros

share

asked 5 mins ago

HootanHootan

1

New contributor

Hootan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

HootanHootan

1

New contributor

Hootan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

HootanHootan

1

New contributor

Hootan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

HootanHootan

1

New contributor

Hootan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

HootanHootan

1