thoughts

hi all and thanks for your time! i am having trouble getting this formula to work. is it true you can only have 7 nested if statements? here is the formula...

I need some help. I have 1000 rows of data from A1:A100 and in each cell a large amount of text appears in each cell. In amongst the text are hashtags (think of tweets on twitter for example). The hashtags could be located anywhere within the cell. Some will have them, some will not. At this...

I recently helped on this thread: https://www.mrexcel.com/forum/excel-questions/1045469-between-if-excel-formula-help.html post #10 with my suggested solution I feel like there should be a more compact way to use PERCENTILE/AGGREGATE in this manner. However, when I tried to use INDEX/MATCH...

If i have A B C D in columns 1,2,3 and 4 respectively, then press CTRL SHIFT L, Excel swaps columns 1 and 2, with 3 and 4!!! Leaving me with C D A B . . . and i can't even UNDO IT! My coworker is fine. Excel 2013, all files, even after a reboot. Thoughts?

Hi guys, I have been given a task and am looking for advice. My boss has 9 customers. These 9 customers are ranked on 12 criteria which my boss has ordered in order of importance. My goal is this: Each of the 12 criteria can have multiple options (this is where the data validation list comes...

All, I have a drop down of dates and then a sumif based on the date. It works for every date but February. Any thoughts?

Article: http://i-programmer.info/news/202-number-crunching/11390-python-for-excel-scripting-under-consideration.html Thoughts? Feelings?

I'm trying to run a sumif to find blank or 0 cells in a column, and if found, give me the corresponding value in the adjoining cell. Normally I would use =SUMIF(AO5:AO344,"",AN5:AN344). However, Some cells in AN have a #DIV/0!, so the formula will not work. Any thoughts?

I am trying to use a formula within a cell and want the answer rounded up =ROUNDUP((235*25%)+235,0) THIS DOES NOT WORK ANY THOUGHTS

I am trying to size my rows and columns by inches, instead of pixels and cannot get it to work. I went to Options>Advanced>Display and changed the default to inches. When I type in these options I get an error message....1/4, 1/4 in, .25 in. Error message - Your entry cannot be used. Am...

I have multiple columns of data and want to create a unique combination of each column's data going down in rows. any thoughts?

Hi, I run a sub routine that does a series of ADO connections to a access database. It is querying and writing to the database. Because of this it is creating a not responding error due to the resources being used and I guess events building up. So I have been researching doevents and was...