CompeteWithPete

heard it was possible, but cant find one article about it. suggestions?

likewise! def going next year ✈️

must go to know. shit was mad skrausage

peace, anyone in london down to sesh hmu. ill be in town starting tomorrow. ✂✂

cool

for real though! this shits gonna be crayzeeee. still didnt book my room in brighton. had no idea hotels are half a mil a night :/ but ill be stayin london thurs/fri. whats the bomb bomb must eat out there??

u from the states?

ill be there! cant wait to finally meet the forum lol.

word man, i just moved here a year ago and just getting acquainted with the scene up here. whats ur insta? perhaps we can plan something out. im @reallyfresh97 👊🏼 definitely!

whats up everyone?! been a while since i posted but want to promote the our newly established Skratcher account. Hosting open table skratch session in the Philly area! follow @skratcherpa on instagram for more updates. Thank you

thx bud. more people should start doing it for sure!

thanks for listening

a short 4 track compilation recorded this year featuring dj knockers and myself. give it a gander

so i have one tab with data with all my data. i have another tab with a macro mining filtered fields. i only want 6 columns in the end of the 30 original columns to paste over. in doing so it pastes each column with running rows into millions when there should only be for example 10 rows of data per column. any ideas how to set range with values indtead of creating a million rows of blanks space?

my crabs arent what they used to be. my muscle memory has changed. not sure if for the better or worse. but i wish i still cut like i used to..

jimmy heavy widit tho. the.........fuck

thx for listening. the beats from freefell one i believe were mostly from the upr records. part 2 was from early loopers by lejad and others.

A collective of freecuts recorded 12 years ago recorded at my dads house in Minneapolis. I am on the vestax 07 and Bach was on the pioneer 909.

thats easy, this is straight from google Select all the data. Go to Home > Conditional Formatting > New rule. Click on Format only cells that contain Change Cell Value option to Blanks Set up formatting you want by clicking on Formatting button. Click ok and you are done!

u truly are next level. if a dj cant speak formula, then u aint sayin nothin. i like typin out formulas so i remember them. i have post its all over my monitor and emails to myself for reference. i emailed this one lol. i was recently was stuck one day thinking about how a reverse vlookup would help me. after some searchin I discovered =index(match it was like man discovering fire

so i just got to work and tried it again and it worked!!!! ur a genius!! i had to type it out a few times and it kept highlighting the 2nd AND statement. i went back and forth with ur post and my screen and i finally saw it.... i had to add a comma before the 2nd AND argument and it worked! i still have more learning to do. i never would of thought to start with 3 statements (if, or,and) then and. im going to im u direct from now on 🙌🏻 thx!

we're still working on 2010 i think at work, maybe 13. i just tested your argument and i get a msg saying "try using an insert function if you're using an =. try an apostrophe... yada yada ". i know this formula is possible and its been driving me crazy all day. i tried THEN instead of OR but i get false values. its what i love/hate about excel. thx for trying tho i appreciate. once i get it ill post my the correct formula

so im bankruptcy dept and need to see when to initiate home reposession depending on delinquency. the cells i need to condition are -d2 (7,13) -f2 (contractual date) - o2 (post date) i just need true or false values. the condition is if a 7 is today()-contractual date > 30 days then true, if not false. additionally i want to add if a 13 is today()-post date >60 then true, if not false. so far this formula takes but only returns false values even if the formula is true: =if(d2="7",and(today()-f2>30,or(d2="13",and(today()-o2>60,0)))) im pretty its and, or, or then.. fukkit i duno, any suggestions??

thank u for listening 🙏🏻🙌🏻

https://soundcloud.com/competewithpete