thinking

Hey guys I was wondering if I could get some suggestions or opinions on the best way to do this. Currently I have some code written that archives all data from the day's work into another workbook. These workbooks are only used to store old data. I'm thinking about changing the way I'm archiving...

Hello, I am working on taking data from one sheet, and saving into a new format to push into computer system. Our job number format is W1234[year][-rev#]. i need to remove the year# (and -rev if it exists). This will be used to populate other cells which do not care about the full W#. I...

Hi I have 16 Userforms. Labeled as Userform1, Userform2.......Userform15, Userform16. I have prompt text boxes in each of these User forms. I need a for a loop that will allow me to run through all these forms allowing me to input code in each form. I was thinking For index As Integer...

Hi, I have an array that is xx(1 to 121, 1 to 121) as double and I want to paste the array to the worksheet. So I did... Range("DM2:IC123").Value = xx But what if the size of xx changes? Is there a way to automate the output maybe using the ubound? I'm thinking I would have to set a...

let's say you have 2 sheets with identical data Was thinking of a way, for tracking changes made in sheet. Was thinking column z on source sheet could contain a formula that states something like =if(PreservedSheet!A1:V1 <> SourceSheet!A1:V1, "1","") Any ideas how to make that formula work; I'm...

Hi guys, I've used Vlookups a few times and testing something here... why is this cell returning 0? Instead of the 6 that I'm thinking it should? Without the "IFERROR" it returns "N/A" Not sure why it's not grabbing the 6 from the holiday days as "paris" matches this row? Maybe I'm doing...

So daily I pull out a pretty large amount of rows with data for our weekly KPI reviews. The rows can be as long as 20k. What would be the most efficiant way of storing this amount of data? I was thinking of PowerPivot tables, but having problem with IT section to get PowerPivot in to Excel...

Hi, I have a pace set up for our sales department. The formula I have in place is =E1/DAY(TODAY())*31 for January. Of course we were closed for the 1st so now my pace is off because it is thinking we have worked everyday but really we were off for the 1st. Any idea how I correct it so it...

On some computers the 'Unlock Range' input box does not show up properly - it appears as a small vertical blue line and people keep thinking excel has crashed as they do not notice it You can enter the password and the range will unlock

Is it possible to calculate how many weeks are in the current quarter? For example, if A1= 4, then B2=13. I was thinking there was an easier way then counting how many weeks each quarter. Thank you in advance for your help!

Hello World! I have 25 employees who I need to create a dashboard for. I am familiar with pivot tables, slicers and timelines but the way the data is compiled I am unsure how to create the executive summary piece. Can you help me create a dashboard that displays the following information...

Hi, I am wondering if a Pivot Table would be the best method to achieve the results we are looking for. We operate a small carrier company and we would like to filter broker contacts based on the lanes we run in. The brokers could have inbound/outbound loads in multiple lanes I am thinking a...

What I am using now: =SUM(T24+T25)/T64 =SUM(V24+V25+Z24+Z25)/(V$66+Z$66) =IFERROR((V24+V25+Z24+Z25)/(T24+T25),0) Trying to see if I can do this. In column B range B6:B60 I have the word Operator in multiple cells. What I am trying to do for each formula is if Operator is in column B. Trying to...

Hi I have names in one column. Lets say I wan to delete the last letter only. I was thinking to use find() and left(). Find() the space and then left() that number -1. Is there anything better? Thank you so much. PS: sorry that does not work. I can not find() the space " ". Find() gave me an...

Hi What is the best way to convert numbers to grades. For example 0 to 50 is F 50 - 60 is C 60 - 70 is B 70 - 80 is A 80 - 100 is A+ What is the best way or formula to do so. I was thinking of If() with logical operations like AND, OR etc Any idea would be very much appreciated. Thanks

I'm calculating range E4:F23. Currently I have this quite lengthy formula where if any cell in my range is empty, I 'm using "0" for my calculation...

Dears i need your assistance in the following : I have a list of employees, their IDs, grades and job titles. For each job tile there are certain Competencies related to it and for each competency it has certain courses related to it. i created a sheet with ID drop down list and whenever you...

Hi, Need your help guys. Can you please check the attached sheet and tell me whether is there a formula where I can pull the numbers from result tab and get it reflected on the first tab? I was thinking if a formula can do this instead of any macros. Thanks a lot for your help. The link to...

Hi, I have an excel doc I want to send to a freelancer to upload onto our website, but can't figure out the specific formula to edit this messy category from Sheet1 into the same categories, Sub Cats, and sub-sub cats in Sheet2. I have about 30 of these all with different formatting but still...

Hello everybody! I hope this is the right session. I was thinking, apart from an excellent knowledge of the tools, what you think are the skills that a good data analyst should develop? I mean like interpersonal skills for example. The more specific you are the better, i am thinking about this...