","title":"Excel","shortTitle":"Excel","parent":{"__ref":"Category:category:microsoft365"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:communit
I'm trying to set up sheet B were if the word "lost" is inserted in column F from sheet A then the values for column A in sheet A for that row is duplicated in sheet B column A, if the value for column F in sheet A is blank then no values are transferred. Can someo...
Page Name for Table Sheet in Excel (Report Builder) page number & records number Page width as a default for the reportserver SSRS Page width of the ssrs report Paging in Local Reports(rdlc) Parameter and filter design to filter values on null, non null and all. Parameter change does not...
in#"Filtered Rows" and this is the code for the Transform file letSource = Excel.Workbook(Parameter1, null, true),#"Appt Paste_Sheet" = Source{[Item="Appt Paste",Kind="Sheet"]}[Data],#"Promoted Headers" = Table.PromoteHeaders(#"Appt Paste_Sheet", [PromoteAllScalars=tr...
=Sheet1!A1 I hope this has helped you. Hello Lynsey, this seems to me to be a very simple reference to a cell. Suppose someone enters their name in cell A1 of a worksheet called Sheet1, then you can display it again in another cell using the following function. ...
Add a custom column with the following "formula"= {1 ..10} Expand the custom column Sort, first by custom then by index Remove columns custom and index Load to a table in Excel This will have copied the initial range 10 times. Change the 10 (above in red) to 1800 in your real...
On the tab called "Data to Load", there is one record which contains the Level Code of SO in the column called Level Code. However, as there are actually two distinct records for SO (as shown on the reference data sheet), we would need to duplicate the line in yellow, one showing ...
Sometimes it duplicates, sometimes it does not. Sometimes I see a blank image until I click around and wait, then it pops back up. It seems to ruin the performance of my sheet. Any luck? did you ever find a solution to this? kudo cou...
I used "Get Data" to pull from my time sheet template to another workbook for the PM. What I want to know, is there a way of duplicating this easily, so that if my staff use the template and copy it across for their own uses, it copies across the link to the PM workbook too wi...
I'm trying to fill the cells with the right text but i'm facing this issue. can anybody help me with this, plesse? Adamreead You have two options. Option 1: Select cell T3. Enter the formula =IF(ISNUMBER(SEARCH(C3,"...")),"O.Two.O","") ...