It spent nine weeks at number one, dropped down for a week, returned to number one for six weeks, dropped down for a further week and returned to number one for a third time for three weeks. The record for most non-consecutive weeks at number one is 18 by Frankie Laine's " I Believe" in 1953. Simply playing or singing on a single without credit will not count, or the top positions would almost certainly belong to session musicians such as Clem Cattini who is reported to have played drums on over 40 number ones. The following is a list of all the acts who are on eight or more UK number one songs with an individual credit (meaning, the main artist or named separately as a featured artist – being part of a group does not count towards an individual's total). MsgBox "Process complete.See also: List of artists by number of UK Singles Chart number ones.
'Delete all rows that don't have a concatenated description in Col.'Enter the last concatenated description.strMyDescription = strMyDescription & " " & Range("N" & rngM圜ell.Row).strMyDescription = Range("N" & rngM圜ell.Row).If Len(Range("N" & rngM圜ell.Row)) > 0 Then.Range("Q" & lngMyRow).Value = strMyDescription.For Each rngM圜ell In Range("K2:K" & Range("K" & Rows.Count).End(xlUp).Row).
CASTOR ASSY (INCL AXLE) X 1 CASTOR WHEEL X 1 AXLE X 1 ROLL PIN X 2 LABOUR X 1.6 HOURS RE: SJC X4829377ĬUSTOMER DAMAGE TO RENTAL UNIT SCP1259 CHARGER LEADS SEVERED DUE TO IMPACT CABLE X 6 MTS CONTACT CONNECTOR X 4 BATTERY PLUG X 2 LABOUR X 3.5 HOURS RE: SJC X4828170ĬUSTOMER DAMAGE TO RENTAL UNIT SX567 LOAD WHEELS IMPACTED - DAMAGED TREAD LOAD WHEEL X 2 BEARING X 4 ROLL PIN X 2 LABOUR X 1.8 HOURS RE: SJC X4823234 This way, I will definitely get the job card number every time.ĬUSTOMER DAMAGE TO WP1575 () REPLACED PLASTIC DAMAGED LOAD WHEEL PARTS LABOUR 2 HOURS $139.50/HR REFER SERVICE JOB CARD X4704633ĬUSTOMER DAMAGE TO IC2821 () REPLACED DAMAGED PRE-CLEANER PARTS LABOUR 1.5 HOURS $139.50/HR REFER SERVICE JOB CARD X4701137ĬUSTOMER DAMAGE TO RENTAL UNIT WP1844 PLASTIC AND CHICKEN FLESH SEIZED IN CASTOR WHEELS/RIGS. I want a formula that rather than finding X then 7 values, it finds 7 consecutive numbers instead. However, some cells have multiple x in them and the formula extracts the first X it finds which in some cells is not the job card. My objective is to extract a job card number that always starts with X. I have formula =IFERROR(MID(F2,FIND("X",F2)+1,7),"") which extract 7 values after the letter "X" from text in cell F2.
0 kommentar(er)
