I have one project where certain tasks are paid by one client and the remaining paid by a another. Example: Data collection paid by Client A, Data Cleaning paid by Client B How would I set this up so …
similar to a bank statement 07-22 Point Of Sale Withdrawal MARTYS FI 61 MAIN 13.99 - SHOPKINTON MAUS 07-22 Point Of Sale Withdrawal PAN THAI 44.38 - RESTAURANTHOPKINTON MAUS 07-22 Point Of Sale Withdr…
I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to…
I took the certification exam back in January as an "early adopter" for my team. Some of the other members are now getting around to taking it and asked me about the practical component (part II) wher…
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would er…
I have data broken out by region (AMER, EMEA, & APAC), and there is budget information contained in each row. The region is a parent and the corresponding rows are children. This allows me to get a re…
Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both…
Hello, I'm having an issue with a cross sheet formula. I'm trying to build a budget tracking system in two parts. It involves a top sheet with a the sum of all expenses by category and an expense log …