setup

I am trying to get this simple. Excel table to work. The idea is show if all trades that are made, whether, Winners or Losers. If the trade is a Long, the exit price need to be higher than the entry price to be a winner, if it is less, then the trade will be a loser. Setup – Long Entry – 10...

Hi, Sorry about the wording of the title, I don't know how best to word this. I have a large number of Excel spreadsheets in subfolders that I wish to obtain information from. Currently, I need to type in the path and filename into each cell. There is a spreadsheet for every single day, and...

Not sure if you need this but here is my info: computer: custom build - Processor Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz, 2808 Mhz, 6 Core(s), 6 Logical Processor(s); Memory - 16GB DDR4-3000; Video - Radeon RX480 8GB; Storage - Intel 600p Series 1TB M.s-2280 SSD and 500GB SSD 2.5"; OS - MS...

I have a workbook that has 54 sheets (a TOC, Setup, and a tab for 52 weeks). In the Setup sheet I have 20 products setup and I have a Y/N column next to each product to determine if that product is being used or not. What I want is, if the product has an N next to it and it is not being used...

racking my brain trying every various combinations of formula, but using the following general setup have the user provide a "name" and a "skill" and have formula return the three most recent dates and corresponding grades. Biggest problem i have is that the raw data is in the format that the...

Good evening! I have multiple sheets in my workbook. Sheets("Setup") and Sheets("Data") are the two sheets I'm looking to compare to find matching values. If any of the the values in Column C of the "Setup" sheet are found in Column E of the "Data" sheet, I'd like to highlight the cell green...

Hola Forum I recently came across a file where the AVERAGE function calculates its value base on the number of all cells no matter if they contain a value or not. Please view the example below: Excel...

For excel 2013, is there a way to setup pivot tables to roll dates. Also, is there a way to link timelines so when one date is changed on one timeline it changes all of the rest?

Hello. I have a macro which runs perfectly on my Excel 2013 system on my home PC. It also works fine on most of the other computers at my workplace. But there's one machine (also running Excel 2013) that when it reaches this bit of code; ActiveCell.EntireRow.Select Selection.Insert...

Is there a way to setup a pivot table to roll dates to keep a constant 12 months rolling, instead it adding on constantly everytime a new date flows in?

Haven't used Excel heavily in a while...now am on Excel for Mac 2011. I remember in a much older version I used that I used to be able to set up the view on the screen to show the page breaks - but it would show all of the worksheet, even cells that would not be printed (so not a page view). I...