Use Dictionary object to track the location (row#) of question index .
The snippet can handle more choices. (eg. Q2 has 5 choices)
Microsoft documentation:
Dictionary object
Range.End property...
Reading/writing cells always take some time. Several changes to improve efficiency:
Load data into array
Write output to sheet all at once
Microsoft documentation:
Split function
UBound function...
Use REDUCE to iterate A2:A3 and get the references
OFFSET to get the corresponding name,
INDIRECT to get the corresponding range from the given reference,
IF/SEQUENCE to create duplicate names accord...
You can achieve this by formula:
=LET(data,A2:C301,idxSortColumn,3,
sortColumn,CHOOSECOLS(data,idxSortColumn),
sort1,SORT(FILTER(data,sortColumn=701)*(sortColumn50)*(sortColumn
If you have datetime/time objects in Excel, the easiest might be to import as string, add the reference date when missing, convert to_datetime and subtract the reference:
df = pd.read_excel('data.xlsx...
Following your idea of using Xlookup, I would use it in a reverse search like this, checking for a matching Matricula where the row number is lower. Assumes dates are in ascending order:
=IFERROR([@[D...
Try this in powequery
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
#"Duplicated Column" = Table.Duplicat...
You need to adjust OldPath so it only is the workbook name, not the full path.
It also helps to declare the workbooks you're going to use and the worksheet the range is in.
Sub RRQP()
'RRQP Macro...
Lost your password? Please enter your email address. You will receive a link to create a new password.
Donate
Thank you for visit here to donate to us, you think it's just a cup of coffee, but with us, it's really meaningful and contributes to help this blog grow more and more.
You can support us in one of the ways below: