8,674 reputation
42354
bio website raystafarian.com
location Florida, USA
age 29
visits member for 2 years, 5 months
seen 12 hours ago

Always trying to learn.

profile for Raystafarian on Stack Exchange, a network of free, community-driven Q&A sites

Stack Overflow Careers 2.0

LinkedIn


12h
comment How can retrieve cell address that match criteria?
What have you tried already? Where are you stuck?
2d
comment Excel Formula Issue Countif to Sumproduct
@CharlesH Only VBA will pull from a closed workbook.
2d
answered Excel Formula Issue Countif to Sumproduct
Jul
3
reviewed Reopen Is there a way to copy with verification or just verify copied data
Jun
18
comment I have scanned a document containing table. How do I export this table to excel?
You have this tagged pdf do you have acrobat? It can save as excel.
Jun
12
comment Convert formulas in table to structural references
If the formulas are near the table, try converting them with the range into the table, they might convert to structured references by doing that, I'm not sure.
Jun
12
comment Convert formulas in table to structural references
Did you convert the range with formula into the table as well?
Jun
11
answered Excel Help: Search Column A, Sheet 1 for same value in Column A, Sheet 2, return value of Column B, same row in Sheet 2
Jun
11
comment Excel - How to count matches in data?
This is best done in a relational database model. Excel will be hard pressed to do this easily unless you setup a macro with dropdowns of each possible step. Give it a shot and then let us know if you get stuck.
Jun
9
comment Excel concatenation of one column based on values in another
@OfficeLackey make sure you're executing it on the sheet that you're working on. Also make sure it's a module in the correct workbook.
Jun
6
revised Is it possible to set a cell color based on the value of the adjacent cell?
added 104 characters in body
Jun
6
comment Is it possible to set a cell color based on the value of the adjacent cell?
What do you mean based on the other value? Do you want to determine the color based on the adjacent cell's color? Or the adjacent cell's value?
Jun
6
answered Excel concatenation of one column based on values in another
Jun
6
comment Excel concatenation of one column based on values in another
What have you tried already? Where are you stuck?
Jun
6
revised Excel - minifs function returning 0
added 455 characters in body
Jun
6
answered Excel - minifs function returning 0
Jun
6
revised Excel - minifs function returning 0
deleted 12 characters in body
Jun
5
reviewed Close Do windows 7 phone, windows 8 phone, and windows 8 share an app store?
Jun
5
comment Excel function working like SQL group by + count(distinct *)?
Yes, you can. A macro would be a lot easier though. start here
Jun
5
comment Excel using INDEX and LIST to return multiple results
check this