Recent content by yearightsure

Another way is to put columns with simple if statements to the side (true=1, false=0) then create a new sheet referencing those columns with a pivot table. Then all that is needed is to right click and refresh. -yRs

there is...and i'm not sure where...a program that allows multiple users to access an excel spreadsheet, in unison, and will sync the data to the main sheet...I used it many years ago...anyone know of it? That would really solve this issue...

use the lookup formula (you can reference any other sheet)...much easier...or you choose()...depending on what you are doing. It looks like you are calculating a range of columns based upon a certain input (probably a period range or month number) to get a year-to-date amount. I'd use...

First post, new to the forum... I have a text file called "test.prm" (ignore the extension...the file is a text file) There are 22 lines of text (as shown below): DBServer=xyz DBName=WTI DBUserID= DBPassword= DBPasswordNotReqd= DBTimeOut=30 MainSize=5670,8625,3510,5430 ViewerSize=...