longest

Hi, Hoping someone can help. This is kinda similar to my previous thread but I think different enough of an issue to warrant a new thread. I have Devices in one column, Memory in another, IMEIs in another and days in stock in another. I want to have a sheet that shows which of each device has...

•••W•••••W11111W22222W•••••••W11•1W1••••••••••W••111•11WWW I have this text string in a single cell and need to count the longest occurrence of dots (in this case 10) can anybody help

I am currently trying to calculate the biggest time in a column for a specific month. Something like the following... <tbody> Month Offered Done Rc ave longest task Sep 1234 7525 125 45.57% 0:15:45 0:01:78 Oct 5481 5165 154 75.89% 0:45:15 0:05:98 Nov 1548 1568 525 98.99% 1:15:15 0:25:87...

Hi and thank you for all help in advance, I have a csv. file that I download and it gives me the data like this (not real data): A B C D <colgroup><col><col><col><col></colgroup><tbody> CallDate DialledNumber CallingNumber...

Hi! I have an excel file which has nearly 30000 observations and 45 variables and I would like to find out the longest cell in each column. I know how I can get the longest cell in a specific column. I use the formula as the following below. Is there a single formula that allows me to get the...

I am trying to count the longest consecutive streak to start a row. For Example: (10 Columns) W W W L W W W W W L would yield 3 W L W W W W W W W W would yield 1 I have a formula to determine the longest consecutive streak but it will find it from anywhere in the columns not just until...

Hey everyone, I have an excel file that I would like to capture the longest streak of cells that contain a number greater than 0. I currently have an array formula in cell J14: {=MAX(FREQUENCY(IF(L14:AM14<>$BI$83,COLUMN(L14:AM14)), IF(L14:AM14=$BI$83,COLUMN(L14:AM14))))} ($BI$83 is just an...