I’m try to expand a table to an exact measurement on BOTH sides. When I use the width adjustments (see below, highlighted by green box) just the right side of the table expands. I want to align the box that surrounds the heading “Electric Charges and Fields” and the table […]
Daily Archives: February 7, 2020
14 posts
I am struggling to find the missing piece to a formula based on two dropdowns with both having the ability to include all the criteria. Can some evaluate this for me? =if(and(D6="All",D8="All"),sumifs(GL!$P:$P,GL!$I:$I,D$15,GL!$AB:$AB,$B17),if(D6=All,sumifs(GL!$P:$P,GL!$I:$I,D$15,GL!$AB:$AB,$B17, GL!$R:$R, $D$8)), if(D8=All,sumifs(GL!$P:$P,GL!$I:$I,D$15,GL!$AB:$AB,$B17, GL!$A:$A,$D$6)),sumifs(GL!$P:$P,GL!$I:$I,D$15,GL!$AB:$AB,$B17, GL!$A:$A, $D$6,GL!$R:$R,$D$8))
VBA: Combine Excel files from multiple folders into one worksheet based on having the same 4 first characters in the file name.xlsx Description: There are files with a customer ID from 001-100. Each customer has 3 different Excel reports (### Report1-3), which are generated into different folders (Folders1-3). For example: […]
I sometimes have a flash drive that is a bootable drive, and would like to use the drive for something else (erasing the files on it) but without losing the option to use it in the future. The simple way would be to backup the files on it and later […]
I want to convert ffmpeg -i input.mp4 -maxrate 63317762 -bufsize 63317762 -map_metadata -1 -vcodec libx265 -c:a copy -crf 28 -color_range 2 output.mp4 into a command that uses cuda to speed the conversion process. I tried ffmpeg.exe -hwaccel cuvid -i input.mp4 -pix_fmt p010le -c:v hevc_nvenc -preset slow -rc vbr_hq -b:v 6M […]