User Profile
anupambit1797
Iron Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Downloading multiple files from excel hyperlinks
Dear experts, Could you please share any Excel formula or PQ solution to download multiple files from excel hyperlinks. Each cell have one hyperlink and there are total > 100 hyperlinks, it's difficult to download each file one-by-one. Thanks in Advance, Br, AnupamFilter function
Dear Experts, Greetings! I have a data like below:- Each row has two rnti's (Col-C and Col-D), and their corresponding numofPrb are in Col-F and Col-G, I want to prepare something like Col-J and K, for the rnti's with their corresponding numOfPrbs in a single column. Thanks in Advance, Br, AnupamHow to set min max bounds for Custom Values
Dear Experts, I have an issue where in Y-Axis , I have time in format h:mm:ss.000, and I need to set min/max according to the data I have (attached) But, seems in the Axis options, not much can be achieved, please share if it's possible and how. Thanks in Advance, Br, AnupamExport Images from Jira to csv/excel
Dear experts , Greetings! I have a query on jira export to csv, when I export jira Tickets to csv , using export to csv as below:- The Tickets are exported properly in csv/excel, but the images used in those Tickets(description, analysis) are shown as below:- I did some Google on this , it says we need to create some kind of scripts for this.. Could you please guide me on how to achieve this or if any such script already existing? Thanks in Advance, Br, AnupamBinaryFormat.Binary , BinaryFormat.Byte,BinaryFormat.ByteOrder,BinaryFormat.Group,BinaryFormat.Lengt
Dear Experts, Greetings, I have a data like below( Most interesting is the Column "E"-> rat0BitMap:- The max size of the Column "E" is 11 bits ( which is max numOfPRB == 162), I want to perform the above functions in this Column "F" which is the BIN of Column "E", but getting Errors in all functions, in PQ microsoft page, their example also I can't see. Could you please educate me/Perform the above 5 functions in Column "F", using PQ, Thanks in Advance, Br, AnupamCommon items and their Count with a Specific Criteria
Dear Experts, Greetings! In the attached Sample, I have an input- Worksheet, whose data is like this:- a) Our interest point is Column "C" and "E"; b) Column "C"(subcellId) has values 9 /10/13 and each of these have SNs(Column E, Sequence Numbers which can range from 0~4095) c) In the Output , sheet, I need to have , the Common SN values and the total count of them in Column B and C, (by Common I mean if any of the SN value is common to 9 or 10 or 13:- d) Important logic/criteria here is that for each SubcellId , once the 4095 is reached SNs will restart from 0... 4095 etc... and so on.. so I tried to do something like below:- for example for subcellId ==9; I tried to break the SNs in sets ( each set has the SNs till 4095, and then another set starts and so on , and then try to make the common SN values for each set per subcellIds and their count.. but it may take more time.. Thanks in Advance, Br, Anupam
