Excel Forum - solved topics
- Solved
-
auto transfer data as i marked Solved/Closed
Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...
-
Counting action under condition of theyr value, and month when.. Solved/Closed
Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...
-
@if formula Solved/Closed
Hello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...
-
conditional Formating a column Solved/Closed
Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...
-
Copy cells based on conditions Solved/Closed
Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...
-
Copying data from workbook to workbook using button Solved/Closed
Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...
-
Change color to different cells based on another cells text. Solved/Closed
Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...
-
Compare two worksheets and Remove duplicated data from one Solved/Closed
Hello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...
-
Search for matches from columns on separate sheets. Solved/Closed
Hello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...
-
How To Copy Data Between Several Sheets on VBA Solved/Closed
Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...
-
values from one workbook to another Solved/Closed
Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...
-
Range of cells depending on a condition. Solved/Closed
Hello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...
-
match cells in excel with all characters same except one Solved/Closed
Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...
-
Auto populate rows from master sheet to other sheets Excel 2013 Solved/Closed
Hello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...
-
script which can check if a debit has a corresponding credit Solved/Closed
Hello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...
-
IF functions with dates Solved/Closed
Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
-
Excel - Compare data in two worksheets Solved/Closed
Hello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...
-
Unable to Convert Date in Excel Solved/Closed
I am trying to change all of the dates in an excel spreadsheet to the mm/dd/yyyy format, but when I go to format the cells, it does not change, even w...
-
Using a comand button to open an external software? Solved/Closed
Hello. I'm using Excel and I need do create a comand button to open an external software, e.g. I need do order that button to open "Profis Anchor f...
-
How to populate a version # change to a text sentence Solved/Closed
Hello, Using Excel 2013 What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those cells t...
-
Dynamic database Solved/Closed
Hello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that refreash...
-
sum different alphabets in an excel range. Solved/Closed
some one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P" and C...
-
Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format Solved/Closed
I have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart bloo...
-
=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>" Solved/Closed
Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated... =IF(F21="CTF",I21*15,IF(L21="CTF",O21*...
-
IF function for "specific date" + 15 calendar days Solved/Closed
Hello, maybe you can help with the following... I am looking for an IF function that alerts me to "PAY NOW" or to "HOLD" as follows; PRODUCT ENTRY ...
-
My compliments, great altruism everybody! Great forum! Solved/Closed
Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...
-
=IF(F9:F46="CTF",I9,"") Solved/Closed
Hello, I would appreciate any help regarding the above formula - =IF(F9:F46="CTF",I9,"") - I am trying to compute a scheme where if any cell betwe...
-
Conditional Cells Filing Solved/Closed
Hello guys :), I use Excel 12. What I need help with is a conditional filling of cells, based on values in different cells/in the certain row. I l...
-
how to use a single part of a cell's date Solved/Closed
So that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008. I need to compare only the year of the date (2008) and if it's true re...
-
Help in Merging Codes Solved/Closed
Hi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...
-
Function has too many arguments... Solved/Closed
Why is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on ...
-
Search for multiple substrings and return different values Solved/Closed
I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string ...
-
Clicking data in one sheet..Saving all those clicked in another. Solved/Closed
Hello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...
-
Same Date in Column A on Mutiple Lines in seperate worksheets Solved/Closed
Hi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...
-
Please help in getting data clubbed in one cell Solved/Closed
Please inform how to get the following information clubbed in a row Data as follows Required data in a ...
-
master sheet to work sheet, Solved/Closed
I have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...
-
Accounts data requires automatic analysis Solved/Closed
Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...
-
custom sorting & calculating average based position Solved/Closed
please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...
-
search word from list, match it copy values next to it Solved/Closed
I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...
-
Concatonating within commands??? Solved/Closed
Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...
-
Comparing columns and returning value Solved/Closed
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...
-
Word "False" kept on Appearing? =IF function Solved/Closed
=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...
-
sumproduct based on relative cell Solved/Closed
Hello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...
-
stack range of data to next empty row in other sheet Solved/Closed
Hello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...
-
Macro that kills a macro when a new workbook is opened. Solved/Closed
Hi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...
-
Excel, how to use macros and conditioning. Solved/Closed
Hello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with certain...
-
Using 'rept' inside 'If' Solved/Closed
Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...
-
date formula Solved/Closed
Hello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first two nu...
-
fetch data Solved/Closed
fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...
-
Need VBA code to create loops Please Solved/Closed
I have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N" is t...