cleaning

I have a report that is generated in an output format that I need to change. I am running a financial detail report for 100 plus properties. The individual properties appear as column headers. The type of spend account appears in Column A. (See below) I need the data to be arranged as such -...

Here is the table, it can have a max of 52 rows. <colgroup><col><col><col><col></colgroup><tbody> Truck Date Cleaned Type Cleaning Next Cleaning Due 1 01/18/19 Weekly 01/25/19 3 01/18/19 90 Day 04/18/19 5 01/19/19 Monthly 02/18/19 </tbody> So what I would like to do is take the last...

Hi everyone. I'm new to PQ but I am working to I'm learning because its obvious it can make my daily life easier. I get data sets off of our test facilities in excel. They are unique data sets, so I do not want to combine them. But they each have the same number of columns and need the same...

I have a list of over 100 buildings. I need to keep track of window cleaning. Each building is cleaned internally and externally once a year and just externally twice a year. I would like to make a way to see which buildings are due for cleaning. Completely clueless, help!!

I have a column in PQ that needs cleaning up. I'ld like to keep values that end with a combination of 1-letter and 4-digits. Keep this pattern: ...A1234 Filter out this value pattern: ...A123 Help is appreciated. Thank you.

Hi guys, I need help on this. I would like to tie and record the car's plate number and turn-around-time for each stage but there's a catch. Read on please. For example: 3 person brings their car in for cleaning and drying. Cleaning stage: <tbody> Name Number Plate Time of entry Car 1...

I have about ten columns with different type of expenses, on one of these columns there will be one expense category. I need a formula that pulls the value on that cell <tbody> Cleaning Supply Empty Cell Empty Cell Formula that pulls Cleaning Supply, the only cell with Value </tbody>

Hi All, From an earlier post, AlanK was able to assist in coming up the formula, which works great. {=IFERROR(INDEX($A$13:$A$29, MATCH(0, COUNTIF($A$2:A2, $A$13:$A$29), 0)),"")} However, If i would Change the A2 to A1, it would give me Errors, since the extract of this is the succession of...

Hi everyone, Long time lurker, I've already learned a lot but I'm stuck here... I need to clean a column based on a list of blacklisted terms stored in another column. Ideally the solution should be flexible enough to extend the list of blacklisted terms (col B) or the list of phrases to...

I'm trying to list all of the unique combinations of five playing cards from a standard deck of cards, and it's taking up more space and computing power than I could ever imagine. But let's just start with a three card combination. There are not enough rows, so I'm getting a huge matrix. So I'm...