eyes

Here's a weird one. Due to the sheer laziness of some team members, they want to enter "1730" into a cell and have it convert to "17:30" Likewise, "530" would convert to "05:30" (5:30AM) I'm literally rolling my eyes because they can't be bothered to just physically write "05:30" (and yes...

Hello there, Hi Mick, Fluff and Rick ;-) I need help on a VBA code that could read a flat table and put the results in a 2D table. The 2D Tables has in rows a list of Animals that is always in the Flat Tables. (no more no less). The 2D Tables is NOT generated, it is the base where the flat...

Hi, can anyone help me with this in Power Query? I'm trying to get data like this first table (Table 1) to look like (Table 2). I understand how to unpivot and pivot in Power Query (and it doesn't work here - I get an error with Sally's hobby) What I don't understand is how to go through and...

Hello i have a list like this:(the list is an example) yellow frog green frog frog frog special frog frog with eyes brown frog with eyes frog with eyes no frog with eyes i want to use countifs to count all the cells with the word frog but if there is the word eyes in the cell dont count it the...