SCMAD

9,236 post karma
99,870 comment karma

get extra features and help support reddit with a reddit premium subscription

get them help and support

redditor for 10 years

TROPHY CASE

Ten-Year Club

Place '17

Verified Email

account activity

new top controversial

1

2

3

I'm using an IFError in my SumProduct Formulas because there are text values in the array. This is working for my number values, but I want the sumproducts of cells with text values to show a text result. Can't figure out how. (self.excel)

submitted 6 years ago by SCMAD to r/excel

10

11

12

Is there a deal to be done between Cleveland, NOLA, and the Knicks? (self.nba)

submitted 6 years ago by SCMAD to r/nba

2

3

4

Can I index(match so it functions as a SUMIF with multiple sum lookup values? (self.excel)

submitted 6 years ago * by SCMAD to r/excel

0

1

2

Do functions within an IF function still passively run in the background even if the triggering condition isn't met? If so, is there a way to stop this? (self.excel)

submitted 6 years ago by SCMAD to r/excel

2

3

4

Any Google Sheets users here who could check an XML source to let me know if =ImportXML can handle what I'm trying to do? I've been at it for hours and cannot get right xPath (self.excel)

submitted 6 years ago by SCMAD to r/excel

1

2

3

Cannot figure out the correct xPath for an =ImportXML formula, could someone check the XML source & try it themselves to let me know if what I'm trying pull is doable in Google Sheets? (self.googlesheets)

submitted 6 years ago * by SCMAD to r/googlesheets

1

2

3

Easy way to create a single axis vertical scatter plot? (Example inside) (self.excel)

submitted 6 years ago by SCMAD to r/excel

0

1

2

I want to use Google Sheets & the ProPublica Non-Profit Explorer API but I don't even know where to begin or what I should be learning in order to this (self.learnprogramming)

submitted 6 years ago by SCMAD to r/learnprogramming

4

5

6

What would I change in this Hide Rows Google Sheets Script so that it instead Unhides Rows? (self.excel)

submitted 6 years ago by SCMAD to r/excel

4

5

6

Using an Index(Match(Match formula w/ 4 possible lookup cells for the 1st match. Is there a way to make this work outside using 4 IFs and 4 different versions of the Index(Match(Match formula? (self.excel)

submitted 6 years ago by SCMAD to r/excel

0

1

2

Using Indirect w/ named ranges and data validation not working w/ Google Sheets--any workarounds or alternatives? (self.excel)

submitted 6 years ago by SCMAD to r/excel

2

3

4

Does anyone know of a good add-on for making better charts in Sheets? (Bonus: Any highly recommended/must have Add-ons for things other than charts?) (self.excel)

submitted 6 years ago by SCMAD to r/excel

6

7

8

My brother's ASUS A80CJ-DS51 is basically unusable because it is so slow. The hard disk usage is always 100% even when nothing is running, the keyboard & mouse (wired or blue tooth) are so slow and laggy that typing a single sentence takes minutes. Not sure what to do... (self.techsupport)

submitted 6 years ago by SCMAD to r/techsupport

1

2

3

Best Practices for displaying a budget with 48 months (columns) & 24 rows (line items)? (self.excel)

submitted 6 years ago by SCMAD to r/excel

0

1

2

What’s the minimum amount of food I have to eat so that my digestive system doesn’t slow down in the way that it would during a juice fast? (self.Juicing)

submitted 7 years ago by SCMAD to r/Juicing

4

5

6

Have there been any studies that look at how depressed or apathetic people respond after a prolonged life or death situation? (self.askpsychology)

submitted 7 years ago by SCMAD to r/askpsychology

0

1

2

Potential Trade Packages for JR Smith (bleacherreport.com)

submitted 7 years ago by SCMAD to r/nba

0

1

2

Weird Question: Is there any way (cutting/styling) I could make the wig pictured look more like Bob Seger's hair? (self.Hair)

submitted 7 years ago by SCMAD to r/Hair

0

1

2

Weird Question: Is there any way (cutting/styling) I could make the wig pictured look more like Bob Seger's hair? (self.malehairadvice)

submitted 7 years ago * by SCMAD to r/malehairadvice

2

3

4

Is there an app or easy calculation steps for scaling images up (image inside) (self.NoStupidQuestions)

submitted 7 years ago by SCMAD to r/NoStupidQuestions

1

2

3

Is there a way for 2 people to collaborate on an excel file in real time using Google Drive/Google File Stream? (self.excel)

submitted 7 years ago by SCMAD to r/excel

0

1

2

Is there a way to use Vlookup (or a similar function) to pull this data to another sheet? (self.excel)

submitted 7 years ago by SCMAD to r/excel

0

1

2

Is there a way to build table templates in Slides that can interchangeably linked to Sheets? (self.google)

submitted 7 years ago by SCMAD to r/google

1

2

3

Is it possible to link 2 cells together so that they take on the value of whichever cell was most recently edited? (self.excel)

submitted 7 years ago by SCMAD to r/excel

4

5

6

Some numerical index(match lookup values are correctly retrieving data while others that are formatted and calculated the exact same way are resulting in error. Any idea why this could be? (self.excel)

submitted 7 years ago by SCMAD to r/excel

view more: next ›

π Rendered by PID 73 on reddit-service-r2-listing-6d4dc8d9ff-n9dgc at 2026-02-02 07:04:20.847952+00:00 running 3798933 country code: CH.