I have a list of data: 8888 H 88 H 888 M 8.888 M How do I remove the H & M to leave a number that I can use in a calculation?
Hello, I am trying get the latest date in a list, subject to criteria but MAX COLLECT does not seem to work. What am I doing wrong? I have tried both a text column and a date column. =MAX(COLLECT({CQ Hours Data Range 6}, {CQ Hours Data Range 2}, Model@row, {CQ Hours Data Range 5}, Batch@row),) Appreciate any suggestions!
Having trouble with random responses from VLOOKUP. What is puzzling is that all options have been copied or transferred the same way but give a different result, any help appreciated!