# Archive by month October

## Transfer Stock Prices to Excel

Hello, I am trying to transfer stock prices from Yahoo Finance and when they are downloaded to excel,are written in this form(34.340.000) and i cant use for …

## Сколько Стоит Покупка Фунта Стерлингов В Банках Украины

Перейдите ниже по ссылке, чтобы получить кредит: https://www.facebook.com/Dengido/ …

## excel RMS formula

I am looking for a formula to (x) squared + (x) squared etc divided by total number  and then the square root of that number.   I have a colum of …

## Linking two or more sheets

Dear Fellow Excel Users, I recently started using Excel, about a week ago. We setup a small wholesale business. I did the easy stuff of making the inventory …

## How to keep an output between a range

Hello, I am trying to come up with an equasion that keeps an output between a range.  I am working with inventory, where we have projected quantities …

## Query in VBA code for pivot table count distinct

Hi, I am using excel 2013 and facing issue to when I am trying to get distinct count of a column in pivot table. below is my code but it is not working. As …

## Professional

I am  a small investor in Shares/ Stocks in Mumbai Share Market. I have used excel to create stock portfolio.  I have bought a few quantity of stocks …

## excel if condition

how to apply if condition for intergers depend on their signs( +ve and -ve) ex   if both are positive             …

## I need Support

Hope you feel fine    I am organizing some tables and i need the below in the last column      SN# Customer Name  order …

## Sorting and Auto deleting long Date and Time series

Hey guys, am a Master student working on a project and I have to deal with huge amounts of data. I have this Meteorological data that takes records with a …

## Sorting and Auto deleting long Date and Time series

Hey guys, am a Master student working on a project and I have to deal with huge amounts of data. I have this Meteorological data that takes records with a …

## Incentive calculation using slab

Monthly Ach% >2.50 2.51-5.00 5.01-7.00 7.01-10.00 <10 <90% 100 200 300 400 500 95-99% 200 400 600 800 1000 100-104% 400 800 1200 1600 2000 105-109% …

## For Money Receipt in Excell

The formula will be in Sheet 2 F8. I want to read a Form number from Sheet 2 B1 wchich form number is also in Sheet 1 C2. Which will read the address of the …

## How to subtract cells with previous embedded formulas

I am trying to subtract two totals in the same column. One of the totals is a result of a SUM formula. I think I need an IF formula, but don’t know how …

## Excel

Hi All I have a query. I have many rows of data on a worksheet. Essentially, there’s a code/name of an individual on cell A2 and the corresponding …

## refreash help

Windows 7 Pro, Excel 2016I have a table that gets updated from an outside source. This table is a list of items on order from many different customers. Every …

## Data validation rule

Hello this may be a long shot but I need some assistance with data validation. We are currently using a new tool to automate firewall requests in our network …

## problem in account number

hey! when i enter my account no. 14*************1 the last” — because it falls within my area of expertise. I just need a few more details about …

## Cell Update

I’m trying to get a cell to add some money to it self when the month changes.   In cell A2 I have =Now() which gives me 10/25/17 In cell B2 I have …

## Formula to pull numbers from the range of data

I need formula that pulls Q4 value into P2:P4 and Q8 value into P5:P8. Pulling it into P2:P3 and P5:P7 works too.     By:

Looking for formula so I can create an email address from a name in an Excel document when the first and last name is in one cell with a space in between the …

## Remove duplicates + Sum

Can anyone help ? i Just want this … Code Name Quantity 111 A 5 112 B 6 117 G 1 113 C 4 114 D 2 111 A 5 115 E 3 114 D 2 116 F 2 117 G 3 … to this …

## Offset, index or match – or combination?

Would like to autopopulate B2:B5 by picking up B1 and cross-referenceing to the Actors List tab (I’m guessing INDEX, OFFSET and/or MATCH). Will upload …

## Extract text

Cell A Cell B 1 Wouter Jan Basson   I want it to return in C1 the following BASSON, WJ   What I know, can you please help me finish? …

## Solver Simplex LP setup with Specific example

2. Sailco Corporation must determine how many sailboats to produce during each of the next four quarters. The demand during each of the next four quarters is …

## IF Formular Help

How can I apply this IF formular to the entire row?   The row (horizontally) cells are for days of the month. In cell D33 underneath I am trying …

## Date range SQL query

Hi, I need some help with excel and a SQL query -(excel 2010) I would like to change dates in cells B1 and B2 – refresh – and get my new query. …

## Reformatting data and columns from vertical to horizontal

hello guys, i need to arrange my excel data’s from this https://www.opendrive.com/file/NF8xNjUxMzY2MjBfanRtOWc to this …

## How to incrase last number of alphanumeric text.

Hello All,   I have column A having Purchase Order Number and in column B having supplier name. Now I have short them wtih Supplier Name and PON. Now I …

## Excel To Send Emails Through Lotus Notes issue

i have issue on VBA Excel To Send Emails Through Lotus Notes   i send mail only to one persoin even i add two or three and on copy send to the first one …

## Detecting Duplicates within a sentence

Row 1: 123, 456, 789 Row 2: 123 123 appeared twice. How do I detect 123 as a duplicate? From my limited knowledge ,i only managed to detect the duplicate if …

## date range in conditional formatting

Hi I have been trying for days to get the conditional formatting to work, but I just cant. what I need my spreadsheet to do is: Highlight cells Red for …

## conditional formula or rule to move data to other worksheet

I have Excel 2013.  I am wanting to make a rule whereby if “Yes” is selected from a drop down menu in cell O39 on “sheet2” then …

## Averaging across sheets

I have a sheet where QA scores are calculated for employees on a regular basis. I want the average of one employee’s QA to auto update in a different …

## Питание Для Похудения При Интенсивных Тренировках

Приобрести можно на веб-сайте http://mangystin.bxox.info Хотим предложить нашим клиентам …

## extracting rows with Blank cells

Hello i have an excel document below is a small section of it 40 #378 Regice Gen 3 Legendary 40 #379 Registeel Gen 3 Legendary   #380 Latias Gen 3 …

## formula needed to add highlighted cells with a tick mark

Hello I use excel 2010 on a laptop supported by Vista (old I know) Im struggling to build a formula which will allow me to add: the number of cells in a row …

## one colum data seprated to many colum in excel

hi,, i have a data in excel a single colum i want separted these difrent difrent colum..by farmula please learn me the farmulla.. By: