manually

Help please... So this seems a bit strange. But then again it may be something some of you may have encountered before. I have a spreadsheet, only 2mb. When i enter figures manually it updates a couple of graphs (no biggie- my laptop can handle this and then some) but it keeps...

How do I make a positive number manually enter into a cell, negative in another cell? <tbody> A B 1 Given I enter a Positive number Manually I want negative number manually entered in cell A2 2 6 -6 3 11 ????? </tbody>

I want to combine my weekly reports into one master file. After I copy paste them into one sheet, I have to go through them manually to match all the rows. There can be 7000 plus rows and it takes all day to manually fix them. What can I do to automate it? V lookup only work on one column. I...

Hello all, I have a list of website bookmarks, not hyperlinked, just text. They are all listed in column A. I know i can select each one and choose "hyperlink" and copy the link and paste it to manually create a hyperlink but is there a formula to automatically create the hyperlink? I have a...

Hello I want to ask some have an idea..? how can i split these numbers automatically from the picture? with a script or no other idea .. The idea is not to remove them manually one by one. The idea is not to manually pull them out one by one, that sometimes there are a lot of accounts, and I...

I am having some difficulty getting this to work correctly. I have a spreadsheet that has columns that indicate various dates, the rows are for various customers, some of which might have multiple inputs on any date. I am looking to create a summary page where I can input a date and have the...

In my schedule I show the start and end times for my employees (see below). On a separate sheet I need to know how many people are working for every 30 minutes. For example, from 9am to 9:30am I can manually count that there is only one person working. From 9:30am to10am there will be two...

Hello All, How can I show the value of the last cell in column H as soon as its dependent cells (column C is Start Time, column D is when one clocks out for lunch, column E is when they came back from lunch, and column F is their total lunch time taken)? column B is the date column C is Start...

Hey, Brand new to the forum and just trying to work out a budgeting problem. Basically, I have (C4*B4) in C2. it works, obviously. But, in the same cell I want to add (C5*B5) + (c6*b6) etc etc all the way until (c85*b85). and then I need it to translate into D column. And henceforth...

Even though my title is Data Analyst, more than 50% of my work is financial. I've written VBA code in the past and when I was first at this job but since I don't have extensive experience, it's not a fast process. My boss likes me to work as fast and efficiently as possible, and I usually have...

Here's an example of what I need: ColumnA 1 2 3 4 6 7 8 10 15 16 Instead of manually hunting down the gaps, is there any way for me to get the above shown in a range, like this? 1 - 4 6 - 8 10 15 - 16 OR 1 - 4, 6 - 8, 10, 15 - 16 OR 1 - 4; 6 - 8; 10; 15 - 16 Thanks in advance!

Hi, I am wanting to add a blank row at the end of my spreadsheet with only the formula's from the row above. Idea being, user clicks a button, new row is added with the formula's from the row above...i.e. none of the manually entered information. Some cells are manually populated by the...

Hi I have some code on workbook open that checks to see the height and width of the active window and it then changes the zoom depending on which criteria it falls into Now when I run it on the workbook open - it doesn’t change to the correct zoom view but when I step through it manually it...

I have a spreadsheet the produces a line chart based on N data points. N is a value in the spreadsheet . I would like the chart that automatically changes with N. I do not want to do it manually.

I fail to understand why the below formulas give different results. When I do the calculation manually, the SUMPRODUCT seems to be giving the correct result. =SUMIFS(J1:J1000,K1:K1000,"<>Pending") Result is 43505 =SUMPRODUCT(--(K1:K1000<>"Pending"),J1:J1000) Result is 53595

Hi there. I'm trying to combine a bunch of cells in the same row into one formula with a pipe | in between the numbers. eg A1&"|"&A2&"|"&A3 etc. Can this be automated so this can be done automatically from the first row in a column with a value until the last row in a column with data. Like A1...

Repeat the items: I have our company interest in corresponding cell that I need to repeat, so, <tbody> 0.50882 1.59915 1.59915 1.62267 1.59915 1.62267 0.52931 1.6075 0.50882 </tbody> Will become, <tbody> 0.50882 0.50882 1.59915 1.59915 1.59915...

<tbody> Fee Structure Admission Security Tution Fee C.Fee 25000 25000 10000 1000 </tbody> <tbody> A1 B1 C1 D1 E1 F1 G1 Admission Security Month 1 Month 2 Tution Fee C.Fee Total 25000 25000 Aug-17 Sep-17 20000 2000 72000 25000 25000 Aug-17 10000 1000 61000 manually enter...

WARNING: I am a rookie when it comes to excel. I am wanting to track attendance to practice and games using excel that I can then send out to people. Currently, I manually go to each practice/game day column and mark yes/no. Then I go and adjust the formula for average attendance. Example...

Dear Mr. Excel.com, My data is in sheet 1 in three columns: Sr. Name Amount (Sr. No. ranges from 10-500 in a sequence) The format is in sheet2 where i get data using vlookup function (manually enter Sr. No. in cell A1 which is used as lookup value) and manually give print command for...