CompeteWithPete
-
Posts
665 -
Joined
-
Last visited
-
Days Won
6
Content Type
Profiles
Forums
Events
Posts posted by CompeteWithPete
-
-
Great to meet you Pete!
Can confirm was much fun
likewise! def going next year ✈️
-
must go to know. shit was mad skrausage
-
1
-
-
peace, anyone in london down to sesh hmu. ill be in town starting tomorrow. ✂✂
-
-
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.
-
1
-
-
Dope. You guys have some ill cutters. We should get some coollabs between DC and Philly going.
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
👊🏼
Have a dope session guys!
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
-
2
-
-
Oh nice. Right on for getting scratch music out there. It's just so freaking hard.
thx bud. more people should start doing it for sure!
-
Hehe that's dope Pete.
Good stuff mate.
thanks for listening
-
1
-
-
a short 4 track compilation recorded this year featuring dj knockers and myself. give it a gander
-
2
-
-
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?
-
I wish I could get my twiddles/crabs to consistently sound like the ones at the beginning of that first file. So ill!
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
-
that's some nice stuff there dude..i really like the beats on the first track
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.
-
1
-
-
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.
-
2
-
-
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!
-
1
-
-
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 🙏🏻🙌🏻
-
installing original 05 fader into handytrax?
in EQUIPMENT & AUDIO PRODUCTION
Posted
heard it was possible, but cant find one article about it.
suggestions?