The discussions
Need help with date and if statement newbie
SolvedHello, I am trying to work out a formula if possible, to determine a date based on a date in another cell. So if the Date in Cell A is 3/1/2015,...
If function help
Hello, I am working on a spread sheet whereby one cell contacts REV and RP and I then want the amount linked to that row to become a negative figure...
Numeric value to word.
How I can create any amount in word format from numeric format automatically or using the formula function in MS Excel Sheet? Kindly showing easy ...
How to interchange the date format
Hello, I have my date format as 01.02.2015 but when we replace the . with / it shows as 01/02/2015 which is 02-Jan-2015. I want to show it as 01-F...
If cell ="text" =other text
Hello, I'm looking for a formula that will help me do the following: If cell contains "Other (please specify)" that value of that cell needs to...
Data is not appear in drop dawn list in filter
Hello, i have some data rows almost 2000 there is black rows between every row. filter did not showing whole data in drop dawn so i can remove empty...
Excel tutor
Hi forum I am new here and I need excel tutorial, can anyone help?
The date that i enter the data
Hello, is that possible to know the date that i enter the data in a cell. for example i enter the data in cell B1 today and i want this date in C1 ...
Generating new document
Hello, I have an internal budget and I would like to use macro to generate another workbook with specific information from that budget with formul...
If formula to identify data outside a timeframe
Hello, I have a excel report that contains data including a date created and inception date. I would like to run a formula that will tell me if the ...
Shortcut/keys in excel
Hi! I'm Jen..I know how to use the Excel, however, I haven't use it for years now and my Job now is Secretary so I will be encountering Excel, Word, P...
Date to words
Hello, sir please tell me in detail steps of converting date to words
How to replace * with / in all formulas in an excel sheet
Solvedhi Guys, does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could not f...
Time calculation (timexnumber)
SolvedHello, i want calculate the salary of workers like the following example. worker No.1 salary/hour 1$ working hours this week 3:45 (3 hou...
Search similar entries
Hi, I need to know, how to search similar entries in list of numeric entries. eg: Suppose I have numeric entries of 6 digits each having number...
Count a value change in cells
Hi, I'm trying to count how many times did 1 cell from a row has been changed from 1 to 0 and then back to 1, how many times did this form of change h...
Conditional formatting based of another cell
Hello, I am attempting to do conditional formatting in Excel 2013. I am trying to make Cell C 3 turn red if cell 1 is 25% less or greater than cell...
How to create a file in makro and copy a row from other makro
Hello, Please help me how to create a new excel file and copy data into this from other excel file. The new file filename will be a column.xls from ...
Transferring data from one spreadsheet to another
Suppose i have a file name tan.xls and another file names rule.xls! then i want to copy all data in tan.xls file in cell D2 - D22 to rule.xls file in ...
Conditional formatting help please
I need some help that could possibly save me a huge amount of time. I'm new to conditional formatting and am working on a new method to help my staff...
Trfing data from master wks to another wks
Hi all...I would to get help from here as I trying to input my project data into my Master list. When we select won or lost under the status for proje...
Populating a work sheet from excel based
Hello, I need your guidance please: I've got a tall order :) I hope you can help me! I am trying to have a new worksheet created from a templa...
Insert images in cells
Hello, Would anybody know how to change this macro https://ccm.net/faq/14170-excel-a-macro-to-insert-pictures-in-a-worksheet so that images are in...
Conditional formatting with range
SolvedHello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out....
If/or formula
SolvedHelp please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...
Copy data from main sheet to another sheet
Hello, I have a document that has a quote on the first sheet. What I want to do is if the code in column C meets a certain criteria, it will auto...
Display value in a cell a7 which is refered to the value in a6
Hello, I want to display value in a cell A7 which is refered to the value in A6 which shows the average of A1:A5 and the value of A6 satisfies the...
Script
Hi Joe here, Sheet 1 Data A B 1001 HE 1002 SHE 1003 HIS 1004 HERS When I type t...
How to save a data excel to non data spreadsheets to excel
Hello, I have a question? How to save a data excel to non data spreadsheets to excel Configuration: iPad / Safari 8.0
Excel, changed format tue, 11 nov 2014 08:14:09" to dd/mm/yyyy
Hello, I'm looking to convert the following excel format of "Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy. Thanks in advance for your answers. j...
Identify same values in column a
Hello, I have an excel sheet with too many rows. But in Column A, I have many values which starts with XYZ. I have to identify them and need to use...
Inserting different photos into cells- macro
Hi, I am not a super savvy programmer, but looking for a Macro that might automate inserting a photo (so user selects image) and then re-sizing the ph...
How we can convert number to word in excel
how we can convert number to word in excel?
Need to create a macro
i have no clue on how to create a macro.i need to copy all items in sheet 1 rows to columns in sheet 2 every time its updated. sheet one will change ...
Shape not showing text in excel
I moke a shape in excel I wrote text in shape but when I click on another cell the text disappears. Please Help!
If function
Hello, I'm having a bit of a trouble working the If Function in excel. Here's my problem: My manager asked me to find the commission fees to cha...
Number that turns in to date.
Hello, hi I'm Nokuthula. I want to ask why when I try to put a number it turn and become a date. Why is that ? Configuration: Windows 7 / C...
How to repeat a row 4 times, while increasing sequence
SolvedHello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...
Using one cell to refer to many
Hello, I'm trying to do something I'm not sure is possible. I have a spreadsheet to keep track of receipts and group items by category. In one column ...
Creating a task reminder for all tasks for that day
I'm hoping someone will be able to help me. I need to attempt to create a task reminder pop up that will list all tasks that need to be done today. An...
Converting rows of data in notepad to columns
SolvedHello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...
Excel
Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with it...
Conditionally copy columns
SolvedHello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...
Find word on sheet1 move all adjacent column values to sheet2
Hello, I have a list of accounts and information on items inside the accounts along with the account owner. It goes like this, A= account number, B...
Change a range dynamically - vba script.
SolvedHi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...
If formula
This formula is killing me! I have a column of numbers E3:E12. These are dollar amounts of bills that have been paid. E13 contains the sum of t...
Date not showing up as a date???
Hello, I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 ...
Conditional formating
I have several rows of data and a legend which needs to apply based on the mutiple values. The idea is that D1/D2 equals a % if that percentage is a...
Macros code
My excel depends on date column.... I have used macros to calculate all my required columns. So when I generate data for today or tomorrow I get on...
Macro for transferring data from one excel to different excel
Hi I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport...
