side

Hello! I have one table with states on the left hand side going down and odd numbers on the top going across. I have another tables with states on the left hand side going down and even numbers on the top going across. It looks like: 1 3 5 7 ... AK x...

Hello, I am trying to figure out a two lookup that will lookup two columns of data, one with an exact match and the other with an approximate match. i.e. My issue, is that when i deal with thousands of Materials, with different scale sets, I pickup the wrong scales with Scale lookup 1. SO My...

I have two tables side by side. I am trying to write a code that will check the column headers in the left table and insert any columns that do not exist in the right table already... and vice versa. Basically I need the two tables columns to match. The issue is that these columns generate...

So I am trying to merge outdated data with updated addresses. Some of the names are the same, some of the addresses are the same, but some are new and need to be replaced. Left side is old, Right side is new. There are THOUSANDS of entries. What do you think would be the most practical way...

I have two tables. One is actuals and one is the budget. I want to create a matrix that shows them side by side and then a variance. I am trying to joined them into one table. I have three coulms that it needs to match in both, location, account, and department. I was also thinking of using a...

Hello, I've used Excel 2016 for about a year now and just this morning noticed that the visual appearance of my High-Low-Close stock charts has changed on every one of my five computers under the account, in every spreadsheet I have. Specifically, the marker that indicates the closing price is...

hi all not one for posting normally as i like to work things out for myself, but this error im having has me pulling my hair out. i found a dashboard online for match results and statistics that i edited to show lineups, goalscorers etc. dependent on the match selected the information will...

How can I sum these values that are separated by a hyphen other than using =LEFT(A2,FIND("-",A2)-1)+MID(A2,FIND("-",A2)+1,2) There will always only be one hyphen and the two values will never be over two digits on each side of the hyphen. Data Range <tbody> A B 1 Count Total 2...

Guys, For the old version of MS Access, I remember someone develope some OCX or something related that was possible incorporate a side Menu. Is there a way we implement the same thing on Access 2010 version onwards?

Hello, So I would like to be able to enter a date and have that weeks worth of data pulled into a location. See Image. On the left hand side, there is the raw data with dates and info. I would like to be able to enter date into right hand side box and have the following 5 days auto populate...

I'm still learning Excel and have watched countless videos trying to figure out this formula but can't find it. I'm trying to add a specific percentage to each line of costs based on what range each number falls between numerically. I need any number 0-74 to have 150% added, 75-99 to add 140%...

Hello, In the attached file there are two sheets. In the first sheet which is Sayfa1 there are datas which repeat in every 4 columns. I need to sort like in second sheet which is Sayfa2 like; at first 2017 , at last 1999. Can you help me about it...

Hello, In the following file, there are datas which changes every 241 rows. My aim that take every 241 row and paste side by side with a blank row between each of them. I tried to show in Sayfa2 what I want. https://www.dropbox.com/s/l5jufqiejcs0qpq/asdsacsa.xls?dl=0

Hi experts, I m back with another vague and cryptic problem, and I ll be honest and say this probably isnt even do able. Imagine an office with 106 staff , 6 admins responsible for organising the appointments of 100 staff. A random schedule needs to be designed on a weekly basis (daily if...

HI, forgive what may be a stupid question, but I have a supplier that sends me a massive sheet with one particular column that contains the following type entry. 2 / 9 or 4 / 11 etc with value on either side of the slash varying. I need to apply a formula the can differentiate and interpret the...

Hi, On a daily basis I have to process documents where each page is divided into two. For example if I get a 24 page long document then the first page's right half is going to be the 13th page, the 2nd page's right half is the 14th page, so first all the left side of page is presented first...

https://www.dropbox.com/s/yqhqrz15glno6xt/Color%20Scale.xlsx?dl=0 I have eight rows of data and a average line for all eight. I was to use the color scale against the average line. So any of the 8 rows that are lower than the average would be on the good side (green.) Any rows above the...

I have made a chart with multiple series and with a secondary axis. When I try to remove the margins on either side of the plot area by selecting "On tick marks" in the "Axis Options" area, only the left side of the graph removes the margin. Is there a way to get the margin on the right to go away?

Hi Guys, I need help. I want to use Icon set - 3 arrows. I want to include an arrow that indicates increase and decrease daily based on it's yesterday data. <tbody> date Cost 12/25 549.38 12/26 821.03 49.45% 12/27 300.23 -63.43% 12/28 360.00 19.91% 12/29 504.00 40.00% 12/30...

Hello dear mrexcel helpfull friends. i have three columns and many rows. this is a dictionary data. A is word B is meaning C is example sentence i want to bring C example centence to under A and B. because when i copy to word file these columns, no space to be side by side. so i need to bring...