![]() So open the dropdown, unselect zero, leave everything else, and then clear these amounts.Īnd I checked with Michelle and she says that the company name, all of the amounts will always be the same.īut what if there was some weird situation where there were two different companies and some of them had a different amount here? The rail right above the cell is equal to the name in this cell.Īnd now we generate zeros and ones, and all of the things that are greater than zero are the ones we want to clear. So we're going to look from A$ that says always start at the heading to A1 without a dollar sign. And I'm doing that with a count if function. Then we need to have a way to check to see if any of the cells above us from A1 down to the cell right above us is equal to the current value. If your data is not sorted by company name. The other rows remain there with the other dates, and we can remove the check column. When we remove the filters, you see that we have the amount on just the first row. So now that we have just the ones we want to clear, we can do control shift down arrow and press the delete key. That's either going to generate true or false all the way down.Īnd then we go to the data tab, turn on the filters, and under check we want all of the trues. I'll just call it check.Īnd we'll say this name equal to the name above us. Michelle needs to keep the amount in the top cell, but clear the amounts in the other cells without removing those rows. So she has something like this, like the company appears with multiple dates and the same amount in every cell. She wants to clear duplicate data from a column.īut keep the rows and not delete or remove the row. Remove duplicate amounts, but there's a twist.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |