User Profile
anupambit1797
Steel Contributor
Joined Feb 09, 2023
User Widgets
Recent Discussions
PivotBy or GroupBy
Dear Experts, Quick question, I have a data like this from Column A~F, and want to make a data like in Col J~L So, I want a summary , that for the slot0 && txnum==1, what are the unique values of numOfPrb, but in case of slot5, we have more than one unique value and it spills, could you please suggest a solution for this, I tried Filter function etc.. may be there's solution within , or if Groupby or Pivotby can help here. Attached is the worksheet, Br, AnupamHow to write a script or any PQ or in Excel to download the zip files from a Webpage
Dear Experts, Greetings! https://www.etsi.org/deliver/etsi_ts/138300_138399/138306/ Could you please help me on how to download the pdf.zip files from above for all the versions? Using a single command in Excel or PQ-option. Thanks in Advance, Br, AnupamRe: Filter function with Time criteria
Thanks a lot m_tarler , how can we extend this to populate this for all the rnti's for lcid==4, in this sheet Note , that each rnti has it's own time difference( it's own machinery), so I don't know first on how to get the time-diff Column for each rnti, and then populate the ones with the criterion's of 0~5ms and so on. Br, AnupamFilter function with Time criteria
Dear Experts, I have a data like below:- For a Single rnti== 17975(say), and in Column No B is the time-difference between each rows for this rnti, for lcid==4 (column=F) I want to populate Column H~K in a way that if the "isStatusReportRequested_" between 0~5ms then "YES" will be populated in Column "H", and so on Attached is the Worksheet, I tried using IF, but not seems this didn't worked:- Attached is the Worksheet. Br, AnupamHow to highlight duplicated sequential rows
I have a data like below sfn can range from 0~1023, and then again start with 0, slots can range from 0~19 I want to highlight the rows like below:- so, 331.12 is repeated in ROWS(4,5) so highlighted in Yellow, 331.13 is repeated in ROWS(6,7) so highlighted in Yellow and so on. if any Conditional formatting or anyother logic, by which we can highlight these data , would be helpful. Worksheet attached. Br, Anupam
