Recent content by jason

..............o_O.......... ill see myself out. hahaha (thank you)

WHOA, its been LOOOOONG time... So I'm working with several numbers that are stored as 5,222 in the cell, but the number represents an assume 'millions'. meaning that if the cell shows 5,550 it represents 5,550,000. I'm trying to create a chart based on this but the chart will obviously plot at...

i understand the request, just wanted to make sure i'm understanding the data... the format, as Narayank said, will not work in the current format...the main issue that i see right now is that all cells are 'text' values... i believe we'd need them to be numerical values inorder to preform...

Does the "Opening Dates" column when that particular store will be 'open', then the Days and Hours? if so, thats going to be a killer

if you turn on the Filter after selecting the Field Names, you should get a drop-down arrow for each field, then under Inquiry, select/check the box next to one of them and that will only show the records/rows with that particular "inquiry"....

^ he beat me....

well theres a ton of data to go through and i cant download it into excel (work restrictions) but i did see that (i think) 2 charts showed a Value Error. are you sure all numbers are actually numbers/values and not just look like numbers/values? same with dates?

that should be do-able.... i'll see what i can work up. hmmm..... may have spoke too soon. my first idea isnt working and i cant focus on this right now with work. hopefully, someone will get a much easier answer than what i would/could. i'll check back when my work load lessens.

awesome!! glad it worked!

correct... how would you like for multiples to be reported? this wil be a biy harder

WELCOME TO CHANDOO.ORG!! what version of excel do you have? how would you rate your experience/knowledge in Excel? do you already have the data in an Excel Spreadsheet? My first suggestion, without seeing how you have the data if it is already entered into a spreadsheet or knowing what youre...

Im not 100% I understand your request... right now, your current method is arranging the data in the same column (like your example)...but you instead want them to be in the same row, going across different columns?! if so, try copying the data as shown in your example, go to A2, Paste...

Try this: this is assuming your data is located in A1:e14 =INDEX(A1:E14,MATCH(MAX(E2:E14),E1:E14,0),2)

create 2 conditional formats using a formula. basically the formula will take todays date and subtract the date given (the exp. date). one rule will see if it is less than 90 days (3months) and format the cell with yellow fill. the second one will see if the date is less that or equal to 0 and...

I dont know where it is now, but Chandoo (or someone) posted a to-do list that had a nice visual indicating % complete based on the number of items checked... FOUND IT!: http://chandoo.org/wp/2013/01/07/todo-list-with-priorities/ this is just the first thing that came to mind... it may not...