Search results

Thank you everyone for the help. Problem Solved <3

Hi @pecoflyer Please have a look at the sheet I have added more data in next rows and while dragging the formula down its giving incorrect answer.

Thanks for your help and suggestion @pecoflyer :)

Please find the attached file, facing issue to calculating the late hours if hours are exceeding from 24. Less than 24 hours formula result is perfect.

Check if its work for you? Paste this formula in E2 and copy down. =TEXT(INDEX(A2:C2,,IFERROR(MATCH("Total",A1:C1,0),MATCH("Total",$A$1:$C$1,0))),"#;;;")

Please see attached file if it works for you.

See the result in attached file with helper column. Hit Like if you find it useful.:)

Copy and paste the formula in cell A10 - for Office 365 =SUM(IF(MID(SUBSTITUTE(B10,"ABC","!"),SEQUENCE(LEN(B10)),1)="!",1,0))

Thank you @mohamed ilyas for your time. This is what I was trying to achieve.

MS 365

Hello experts, Would you please help me split the text into three columns, I've tried several approaches since yesterday, but nothing seems to work.

Try this in Cell C2 =MID(A2,SEARCH("VRM",A2),SEARCH("-",A2,SEARCH("VRM",A2))-SEARCH("VRM",A2)) and in Cell D2 =TEXTJOIN(",",TRUE,TEXTBEFORE(TEXTSPLIT(B2,,CHAR(10)),"-"))

Perfect. Thank Bosco <3

Thanks Vletm, In my previous post, I mentioned dummy data, but for real-time data, this approach does not work. Something like this is required.

See the screenshot while replying to the same post. Even getting this error system will post the the tread.

I noticed this error first time and didn't report to anyone yet. And unable to delete the post from my end.

Hello everyone, Thank you for taking the time to review the file.

Hello everyone, Thank you for taking the time to review the file.

Could you provide the manual required result what exactly you want to retrieve.

Office 365 Solution =FILTER(raw!$A$2:$D$8,(raw!$A$2:$A$8=results!A1)*raw!$B$2:$B$8=LARGE(raw!$B$2:$B$8,1))

Try this formula =SUMPRODUCT((ROW(INDIRECT($A2&":"&$B2))>=EOMONTH(C$1,-1)+1)*(ROW(INDIRECT($A2&":"&$B2))<=C$1)) See the attached workbook.

Try this formula in Cell E2 and drag over and down. =IFERROR(INDEX($A$2:$A$12155,SMALL(IF($C2=$B$2:$B$12155,ROW($B$2:$B$12155)-ROW($B$1)),COLUMNS($E$2:E2))),"")

Hi Experts: Kindly see the attached sample file where I would like to show cell bar chart based on days falling in the mentioned month.

Try this formula in B3 with Ctrl + Shift + Enter =SUM(MID(0&A3,LARGE(ISNUMBER(--MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1))*ROW(INDIRECT("1:"&LEN(A3))),ROW(INDIRECT("1:"&LEN(A3))))+1,1)*10^(ROW(INDIRECT("1:"&LEN(A3)))-1)) And in C3 =TRIM(SUBSTITUTE(A3,B3,"")) See the sample sheet as well.

Check the expected result with helper column.